View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?