display sheet choices in combo box
 

Is it possible to have a combo box give the user a choice of sheets within a
workbook, and to then open the selected sheet?

Wazooli

display sheet choices in combo box
 

Yes, but why bother? You can do the same thing by right-clicking on the
VCR-type buttons at the bottom left of the workbook window.

--

Vasant



"Wazooli" wrote in message
...
Is it possible to have a combo box give the user a choice of sheets within
a
workbook, and to then open the selected sheet?

Wazooli

display sheet choices in combo box
 

Sub Drpdwn_Click()
Dim sSheet as String, sName as String
sname = Application.Caller
With Activesheet.DropDowns(sName)
sSheet = .List(.ListIndex)
End With
Worksheets(sSheet).Activate
End Sub

To load you forms Dropdown/Combobox

sub LoadBox()
Dim sh as Worksheet
with Activesheet.DropDowns("Drop Down 1")
.RemoveAllItems
for each sh in ThisWorkbook.Worksheets
.AddItem sh.Name
Next
End With
End Sub

--
Regards,
Tom Ogilvy


"Wazooli" wrote in message
...
Is it possible to have a combo box give the user a choice of sheets within
a
workbook, and to then open the selected sheet?

Wazooli