View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default How do I create a macro to switch sheets

Suzie,
A simple possibility is Userform with a combobox containing
sheet names.

HTH

Private Sub ComboBox1_Change()
Worksheets(ComboBox1.Value).Activate
End Sub



Private Sub UserForm_Initialize()
For Each Wks In ThisWorkbook.Worksheets
ComboBox1.AddItem Wks.Name
Next
End Sub

"suzie" wrote:

Hi everyone:
I heed some help to create a form that I can use to switch sheets. The
reason is I have a workbook that has so many sheets I can't always see them
all.
I do have some VBA experience and will be abe to edit.

Thanks for your help

Suzie