List box, Combo box

P

P-C-Surgeon

Is it possible to select an existing item in a drop down menu, such as
list or combo box, and have it link to another sheet tab, for exampl
sheet2 or sheet
 
I

icestationzbra

yes, it is possible. it involves writing a macro for that combobox o
listbox
 
R

Ron de Bruin

Hi

You can do this if all the sheets names are in the combobox

Private Sub ComboBox1_Change()
Sheets(ComboBox1.Value).Select
End Sub
 
Top