I assume you mean the list option in Data = Validation

If you are using Excel 2000 or later, then making the selection should
trigger the Change event.

Use the Target argument of the Change event to see if it was your dropdown
cell which triggered the event. If so, check the value and then execute
code that positions the selection in accordance with the value of Target.

See Chip Pearson's page on Events for general information on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"John" wrote in message
...
What code would I need to be able to Select a Month from a drop down list,
then jump to the area of my worksheet that the month is situated. Its like
a
GOTO command except I'm selecting from a drop down list.

I can create dropdown lists and can create a macro to goto a specific
cell,
but how do I incorporate this within a drop down list?

Thanks