Hi,

Like many I am only just trying to find out how much I can do with excel !! However, being so green I dont know how to achieve what I want to .....

I have a drop down list with 5 choices (MKT, PPL, EVT etc). I can select an option, but then want to go to a sheet within the workbook (worksheets renamed as MKT, PPL, EVT etc to match options).

What VBA code do I need to enable a button to allow me to "jump" straight to a specific cell on the worksheet that matches the choice selected from the drop down list ??

Many thanks in advance for any help.

Cheers,
Ross

Sheet["XXX"].select

Anyway, your best help, is to record a macro that do exactly whay you need (in this case jump to a sheet)... and see what excel does for you ;)

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

Thank you