assume the button uses the worksheet name as a caption

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

--
Regards,
Tom Ogilvy

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


---
Message posted from http://www.ExcelForum.com/