Simple Navigation Macro

[RickGreg]

I have used a dropdown box to list several locations in my spreadsheet
(names = Location1, Location2, Location3, etc.). The dropdown box results
go to a cell named "destination". So, if Location2 is selected,
destination="Location2".

I would like to create a button that says "GO" and sends the user to
whatever location is selected from the dropdown list (the "destination").

I have been trying to create a macro to do this using the "go to" command,
but I can only get it to go the the cell named "destination", not the cell
referenced in destination.

Any suggestions?

Many thanks,

-Rick

Excel 11.3.7
OS 10.4.11

 

[Bob Greenblatt]

I have used a dropdown box to list several locations in my spreadsheet
(names = Location1, Location2, Location3, etc.). The dropdown box results
go to a cell named "destination". So, if Location2 is selected,
destination="Location2".

I would like to create a button that says "GO" and sends the user to
whatever location is selected from the dropdown list (the "destination").

I have been trying to create a macro to do this using the "go to" command,
but I can only get it to go the the cell named "destination", not the cell
referenced in destination.

Any suggestions?

Many thanks,

-Rick

Excel 11.3.7
OS 10.4.11

Try using Select, rather than go to. If these areas are already defined
names, try using F5 instead of a macro. Does this work for your needs?

 

[RickGreg]

Try using Select, rather than go to. If these areas are already defined
names, try using F5 instead of a macro. Does this work for your needs?

Thanks for the quick reply.

I have dozens of other named ranges in this workbook, and do not want to
confuse users by making them select among all the range names, so I've
concluded a macro is needed. (This sheet will be used by many and I need it
to be easy to use and relatively dummy proof)

I'm a complete syntax dummy myself... Usually I use "record" for creating
macros. Can you suggest syntax that would get me to the range name that is
referenced in a given location?

Am I making sense?

 

[RickGreg]

Try using Select, rather than go to. If these areas are already defined
names, try using F5 instead of a macro. Does this work for your needs?

Bob- I figured it out on my own using: Range("destination").Value


THANKS!