Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run Macro after item is selected from drop-down list

Status
Not open for further replies.

LisaBee

Technical User
Jun 23, 2006
18
US
I used data validation to create a drop-down list in cell b5 and named b5 "SelectRSM". Once the user selects a value from that list, I want to run macro "revise format". The macro itself runs fine when I request it, but I don't know how to get it to run automatically once the user selects a value from the drop down list. Can someone please head me in the right direction?
 
Perhaps the Worksheet_Change or Worksheet_SelectionChange event procedures ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top