Thread
:
How do I change a worksheet in Excel by using a combo-box?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
How do I change a worksheet in Excel by using a combo-box?
Possibly
Private Sub Combobox1_Click()
if Combobox1.ListIndex < -1 then
Worksheets(Combobox1.Value).Select
end if
End Sub
This assumes the text in the combobox is the name of the sheet.
--
Regards,
Tom Ogilvy
"Pedro Serra" <Pedro
wrote in message
...
I want to change the worksheet in Excel by choosing it in a combo-box that
displays 18 diferent options, and each one of these options displayed in
the
combo-box, corresponds to a diferent worksheet, is it possible?
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy