VBA Button to switch worksheet(s)

  • Thread starter Thread starter marola20
  • Start date Start date
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
 
Have you tried recording a macro?
Sometimes the simplest solutions do the trick... :
 
assume the button uses the worksheet name as a caption

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