I have created a Form with a combo box drop down
selection with a list of names in the drop down and the
form also contains a command button whcih I have
called "OK".

How do I return the Name selected from the drop down to a
designated cell once the user clicks OK?

Sheets("Sheet1").Range("A1").Value = _
UserForm1.ComboBox1.Value

-----Original Message-----
I have created a Form with a combo box drop down
selection with a list of names in the drop down and the
form also contains a command button whcih I have
called "OK".

How do I return the Name selected from the drop down to a
designated cell once the user clicks OK?

.

Use the form toolbar to create the drop down boxes.
Then right click on the drop box and select format
control, and choose the control tab
link the control to the cell immediately behind it.
Then quickly write a macro that copies the value of the
cell to the other displaying the value and you are
finished.

You may need to create a list of names somewhere so that
control can access them. The linking can also be done from
the control tab.

Nick


-----Original Message-----
I have created a Form with a combo box drop down
selection with a list of names in the drop down and the
form also contains a command button whcih I have
called "OK".

How do I return the Name selected from the drop down to a
designated cell once the user clicks OK?

.