Drop down menu in macro
Closed
Rakesh
-
22 Jun 2010 à 10:17
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Jun 2010 à 19:01
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Jun 2010 à 19:01
Related:
- Drop down menu in macro
- Menu déroulant excel - Guide
- Virtualbox drag and drop - Guide
- Show volume in menu bar mac - Guide
- Cs 1.6 cheat menu - Guide
- Chrome menu settings - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
24 Jun 2010 à 19:01
24 Jun 2010 à 19:01
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
