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?