Excel form with Combo Box 1

[kabushnell]

I have code that creates a user form with a Combo Box. I would like this form to open after a macro runs with some worksheet formatting. This will allow a user to select from the combo list and input a value into cell D1. I am not sure how to get the code to open the form and when a choice is selected insert the data into cell D1

 

[PHV]

Have a look at the Load instruction and/or the Show method of the UserForm object.
Set the ControlSource property of your ComboBox to "D1"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886