Drop Down Lists and Macros

C

ChelmsfordCT

Joined
Aug 1, 2011
Messages
2
Reaction score
0
Hi,

My first post so be gentle!

I am trying to write a macro (application.goto) but want it to look at cell a1 (where I have a drop down list) and use the cell value (e.g. Dave/Chris/Steve) to feed into the macro so it will go to the correct sheet.

i.e. When A1 is Chris adn I click a button it will take me to Cell a1 on the Chris tab and so on for when I change the drop down list value

Thanks All!!

:cheers:
 
Ian

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Welcome to the forums :). You've not actually said which bit of software you are using? Excel I guess?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop-down list and error message 1
Pasting cell contents into a macro 1
How to keep formula and be able to input value in cell? 0
Drop Down List Quicker Selection 4
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Data Validation and drop-down list using IF, AND and what else? 8
Excel Excel: How do I put a formula in a drop down list 11
How to Link drop-down list? 2

Top