Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having A Macro Run When A Selection Is Made
I have a combobox on a userform with a drop down list consisting of the 12
months. When I select a month I want the corresponding macro to run. Example-After selecting January macro4 will run: Sub Macro4() ActiveSheet.Unprotect Application.Goto Reference:="PAYMENTS!R1C16:R1C32" ActiveSheet.Protect End Sub Private Sub cbomonth_Change() If cbomonth.Value = "January" Then Macro4 I am having trouble in what to add above when I select February(Macro3) Sub Macro3() ActiveSheet.Unprotect Application.Goto Reference:="PAYMENTS!R1C35:R1C51" ActiveSheet.Protect End Sub which I want to bring me to Application.Goto Reference:="PAYMENTS!R1C35:R1C51" Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box selection only shows bound column info after selection made. | Excel Programming | |||
Combo box disappears after selection made | Excel Discussion (Misc queries) | |||
How to recalculate a worksheet when a selection is made | Excel Programming | |||
Having A Macro Run When A Selection Is Made In A List Box | Excel Programming | |||
Macro to change list box input range based on selection made in another cell | Excel Programming |