Catching a value from a dynamic drop down list

[madhatter40]

I currently have a drop down list located in G2. I want to write VB code to capture the value selected and based on that value run a certain macro. Any help would be appreciated.

[Trebor76]

Hi there,

Try this event macro on the sheet in question - just change the case statements and macro names to represent your data:

Please Login or Register  to view this content.

HTH

Robert