Macro activated by list selection

[Tim156]

Hi I am new to the message board. I am able to record my macro but I am wondering how to activate the macro when I choose an item from a name list that I have created.

 

[Dryver14]

is it one name from a list that starts the macro or a macro per item in the list?

 

[Tim156]

A macro per item in the list. My list has three citys. Gargen City, Victoria and Wichita.

If I choose Wichita from the Drop list I want the macro to run and unhide the sheet called Wichita. Thanks.

 

[Dryver14]

what sheetname and cell is the list in?

 

[Tim156]

The sheet name is Weely Volume and the cell is in c4.

 

[rosenbe]

Are you referring to the Name Box up on the top left hand corner of the screen (to the left of the formula bar) or are you talking about a list using Data Validation?

If it is the former, you could run the event off the sheets SelectionChange event, insuring that Target is the same as your named range.

If the later, you could use the Change event and validate by both Target and Target's value.

 

[Tim156]

A list using data validation.

 

[rosenbe]

The code could look something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = "$C$4" Then ' Address C4 as given
    If Target.Value = "Run Macro1" Then Macro1 ' List Option and Macro name made up.
  End If
End Sub

 

[Tim156]

Thank You!