Drop down menu in macro
Closed
Rakesh
-
Jun 22, 2010 at 10:17 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 24, 2010 at 07:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 24, 2010 at 07:01 PM
Related:
- Drop down menu in macro
- Show volume in menu bar mac - Guide
- Spell number in excel without macro - Guide
- Huawei test menu - Guide
- Ps3 game not showing up in menu - Guide
- Winmerge context menu - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 24, 2010 at 07:01 PM
Jun 24, 2010 at 07:01 PM
not entirely clear what you want. It seem that you are changing a value in one cell and you want to trigger a cascade of changes. You would have to use macro. How ever macro can be triggered by onchange event . YOu would need to define routine
Private Sub Worksheet_Change(ByVal Target As Range)
Application.Enableevents = false
... you code goes here
Application.Enableevents = true
End Sub
this would go on the sheet where the drop down
Private Sub Worksheet_Change(ByVal Target As Range)
Application.Enableevents = false
... you code goes here
Application.Enableevents = true
End Sub
this would go on the sheet where the drop down
