- 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!!
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!!
. You've not actually said which bit of software you are using? Excel I guess?