Input Box w/Drop Down List
John, I like your method. I did not know this was available.
"john" wrote:
If you just want something that shows a list of all worksheet names in the
active workbook & from user selection, then selects choosen sheet then
following may do what you want:
Sub SelectSheet()
If ActiveWorkbook.Sheets.Count <= 16 Then
application.CommandBars("Workbook Tabs").ShowPopup 500, 225
Else
application.CommandBars("Workbook Tabs").Controls("More
Sheets...").Execute
End If
End Sub
--
jb
"PMarble" wrote:
I need to have an input box launch that would provide the user with a drop
down box of selections, then upon their selection, would take then to a
certain sheet of a workbook.
I can write the macro - what is baffling me is how to program the drop down
list into the input box instead of having the user type something.
Can this be done?
|