Hi, I'm very new to programming but have a work question. I have a list of names that I'd like to place a button next to each. I have a separate worksheet for each name in the list. I've like the macro in the button to simply just go to the respective worksheet. I obviously know how to do this the hard way, 1 at a time, but is there anyway to write a macro to do this?
Would you be able to post an example of your workbook?
Just make up numbers and names if it's sensitive information.
It'd be very helpful to know what kinda layout exactly we're talking about.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Why not just use hyperlinks? You can add them with VBA, some suggestions here
http://www.excel-it.com/vba_examples.htm
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Another option:
For each corresponding sheet in your list, name a cell (say A1) on that sheet with the same name (exactly as it appears on the list). Then you can simply use the drop down in the Name Box to select the name and Excel will immediately navigate to that sheet.
The Name Box is located just to the left of the formula bar and generally displays the active cell reference.
To name a cell on the active sheet:
Make the cell active
Click into the Name Box and type a name
Press the Enter key
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks