VBA Button to switch worksheet(s)

M

marola20

Could someone please give me a bit of help with this. I am trying t
program a series of buttons that will take a workbook user to
specific worksheet within the workbook. I know my way around VB bu
this VBA stuff is tricky. Thanks for the help
 
A

alexm999

Have you tried recording a macro?
Sometimes the simplest solutions do the trick... :
 
T

Tom Ogilvy

assume the button uses the worksheet name as a caption

Private Sub Commandbutton1_Click()
worksheets(Commandbutton1.Caption).Select
End Sub
 
Top