Drop down menu in macro Closed

Question

Hello, 

I have a quick question. If I run a macro which includes having various options as drop down in cells, how do i make sure that all the formulas in relative cells change when  I change in the drop down without running the macros again. I hope i was clear

Thanks 
rakesh

rizvisa1 · Answer

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

Drop down menu in macro

1 response

Similar discussions

Subscribe To Our Newsletter!