Recent content by 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...

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...