Variable Button Labels

[kdp]

I am a novice at VBA. I have a spreadsheet with multiple tabs. On the main one, I input a set of names. I also have a column of buttons, each of which when clicked runs a macro which jumps to one of the tabs. I would like to label each button on the navigation bar with a corresponding name that was input on the main tab. For example,
On button#1, I would like the label to read what is input for Name1
On button#2, " " " " " " " " " " Name2
etc.

I have this same navigation bar on each tab and would like the variable names to show up on each tab. How do I accomplish this?

 

[Mr. B]

kdp,

I am somewhat confused. Are the Sheet names not always the same? Is there something that is changing the names of the sheets? What am I not getting?

 

[kdp]

The sheet names remain the same. Let's say they are named Sheetname1, Sheetname2, etc. and the user inputs "Frank" for the input field for name1. So I want the label for the first button on the navigation bar of buttons to read "Frank". By clicking on the button "Frank", a macro would run and cause the sheet "Sheetname1" to be displayed. The user would not see any sheet tab names at the bottom of the screen.

 

[Mr. B]

I really don't think you will be able to do this with simply a Macro. I think this will require you to write some VBA code to assign the value to the various buttons on the various sheets.

If you would like to post your spreadsheet, I will look at it as see if I can get a better understanding of what you want to do and see if I can help.

 

[ezfriend]

Here is an example excel file. Press Alt+F11 to see the vba code.