List box, Combo box

[P-C-Surgeon]

I can't seem to get the selection in the combo box to take me to a
different Sheet tab. I tried pasting in the code and it lets me select
from my sheet tabs, it just doesn't take me to the tabs. Any ideas?

 

[Ron de Bruin]

Use a combobox from the controltoolbox (not forms)

 

[jeff]

Hi,'

Be sure that the combo box you selected shows
a "Properties" item if you right click on it. If you
choose the other combo box (it's called a dropdown if you
right click on it) the code won't work. There are
two types of controls available which work slightly
differently.

jeff