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