Combo box

M

Monty

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
 
M

Mangesh Yadav

Yes you can.

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

should do the trick.

Mangesh
 
M

Monty

Thanks

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

Monty

Thanks

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