Formula for dropdown list
Solved/Closed
love2garv
Posts
11
Registration date
Wednesday September 16, 2009
Status
Member
Last seen
June 16, 2011
-
May 8, 2010 at 08:13 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 8, 2010 at 08:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 8, 2010 at 08:44 AM
Related:
- Formula for dropdown list
- My contacts list names - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Whatsapp country code list - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 8, 2010 at 08:44 AM
May 8, 2010 at 08:44 AM
You would need to define event Worksheet_Change in the sheet where this drop down will be shown
Steps
1. Press ALT + F11
2. Press CTRL + R
3. Double click on the sheet where this calculation will occu
Steps
1. Press ALT + F11
2. Press CTRL + R
3. Double click on the sheet where this calculation will occu
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myFormula As String
If Target.Column <> 2 Then Exit Sub
On Error GoTo End_Sub
Application.EnableEvents = False
Select Case Target
Case Is = "greecing"
myFormula = "=C" & Target.Row & " + 25000"
Case Is = "tyre change"
myFormula = ""
' other cases go here
Case Else
myFormula = ""
End Select
Target.Offset(0, 2).Formula = myFormula
End_Sub:
Application.EnableEvents = True
End Sub
