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?

.