Combo box

[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

 

[Mangesh Yadav]

Yes you can.

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

should do the trick.

Mangesh

 

[Monty]

Thanks

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

 

[Monty]

Thanks

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