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
|