Sorry Tom but this code is not suitable for what I'm trying to do because, I
need to change the worksheet by selecting it in a combo box, not that the
combo assume the name of a worksheet!

For example, in the array I have Sheet 2, Sheet 3 and the combo box is in
Excel's sheet 1. When I choose in the combo box Sheet 2 I should go to this
worksheet

Do u think u can help on this?

Thanks in advanced!

"Tom Ogilvy" wrote:

In design mode, right click on the combobox and select view code. This
should take you to the click event of the combobox and you can see what the
name is.

--
Regards,
Tom Ogilvy

"Pedro Serra" wrote in message
...
Tom I'm starting with programing and I think I understood the code u wrote
to
me but how can I Know the name of the combo-box I've created, because in
your
example u call it Combobox1, right, but in Excel the combo-box as a
different
name, right?

"Tom Ogilvy" wrote:

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?