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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to assign a worksheet in VBA 3
Excel crashes and restarts when accessing newly created worksheet 2
Referencing command button on worksheet from VBA 3
Remove buttons from worksheet programmatically 1
Drawing Objects with vba and workbook/worksheet 3
Code to select active workbook worksheet(s) in Excel 2007 2
What is the VBA for the Excel 2007 "Switch Window" command button? 6
Programmaticlly sign and password protect a VBA Project in Excel 2 6

Back
Top