List box, Combo box

  • Thread starter Thread starter P-C-Surgeon
  • Start date Start date
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
 
yes, it is possible. it involves writing a macro for that combobox o
listbox
 
Hi

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

Private Sub ComboBox1_Change()
Sheets(ComboBox1.Value).Select
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box dropdown data 20
Add a combo box 1
Link cell to combo box 2
List within a list 4
Combo Box and VLOOKUP 7
Combo box output excel 2007 2
drop down list should remember selection. 6
Combo box VBA error 5

Back
Top