Excel 2007 : Assign macro to Drop down

[volar]

Hello,

I want to assign a macro to a dropdown. The dropdown was created with Insert-Form and contains around 30 values .
The macro should do as follows : when a value is chosen, go to a certain sheet in the same file .

I created the macro , see below, but it does not work . What am I doing wrong ? I have read posts related to this topic, but, as I am a beginner, I still did not solve it.

My macro :

Please Login or Register  to view this content.

[jraj1106]

Hi

What values do u have in the combobox?
Upload ur sample file....

[volar]

A list of texts in the same sheet chosen with Format Control->Control-> input range .

[volar]

Please help ! Can you give me some advices ?

[royUK]

Your post does not comply with Rule 3 of our Forum [/I]RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Click Edit to see how I've done it.

The Dropdown will have a linked cell property if you right click it, set it to say A1

Please Login or Register  to view this content.

[volar]

My mistake !
Thanks for your help !

[volar]

Hello ,

I come back with the same problem.
I have tryed the method above, but I still get an error related to the selection of the sheets.
Thank you in advance !

[volar]

I've done it ! )

Thank you so much, royUK !