newbie question

C

cyclingsal

Hi
I am would like to set up a listbox that would then activate the
worksheet of interest to the user. My question is that a combobox can
be set up in a worksheet or in a userform. What are the advantages of
setting it up in a userform as opposed to a formatted worksheet (say
in a new window)? Or is this really a matter of preference?

Thanks in advance

Sal
 
J

Jim Rech

This is the sort of thing that userforms are designed for. I assume you're
creating a generic utility that would work with any workbook.

By the way, there is something built into Excel to show/select sheets:

Sub ShowSheetList()
On Error Resume Next
Err = 0
'Try to show dialog for >15 sheet workbooks
CommandBars("Workbook Tabs").Controls("More sheets...").Execute
'If an error there are fewer than 16 sheets so show the "short list"
If Err <> 0 Then CommandBars("Workbook Tabs").ShowPopup
End Sub

--
Jim Rech
Excel MVP
| Hi
| I am would like to set up a listbox that would then activate the
| worksheet of interest to the user. My question is that a combobox can
| be set up in a worksheet or in a userform. What are the advantages of
| setting it up in a userform as opposed to a formatted worksheet (say
| in a new window)? Or is this really a matter of preference?
|
| Thanks in advance
|
| Sal
 
Top