Thanks

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

"Mangesh Yadav" wrote:

Yes you can.

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

should do the trick.

Mangesh




"Monty" wrote in message
...
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