That's what it was...I had it linked to a Change event.

Thanks a lot Bob
-----Original Message-----
Why not just use

Worksheets(Combobox1.Value).Activate

in the code linked to the combobox click event?

--
HTH

-------

Bob Phillips
"Todd" wrote in
message
...
I have a ComboBox that is populated by all of the
worksheets contained in a workbook. I would like to
select
a worksheet by using the ComboBox. I haven't been able
to
get anything to work. I would imagine you would assign
the
combobox value to a variable and select the worksheet
using the variable name or is there a better way?

Thanks,

Todd


.