Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if i set up a combo box in worksheet 2 can i have the name a select in this
combo box put into a cell in worksheet on.

thanks for your help
 
Yes you can.

Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value

should do the trick.

Mangesh
 
Thanks

this worked . however i have decided to use cell validition and transpose.
 
Thanks

this worked . however i have decided to use cell validition and transpose.
 
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 2
Getting Combo boxes to change options based on other Combo boxes. 1
Having trouble with combo boxes. 11
Choose a value from a combo box based on a text box 0
Access Control on subform / combo box requesting parameter 0
combobox into another combobox 1
Access MS Access Listbox not saving to bound field 0
Combo box selection will not calculate 5

Back
Top