How do you open a file with the cursor in a combo box?

I want my end user to be able to open an excel file which I'm using as a form. I have combo boxes where I want the cursor to be so the user can easily start entering information. When excel opens, the cursor currently goes to an unprotected regular cell. How do I designate the cursor to start in the combo box I want the user to start in?

Nope, but thanks for trying. I replaced "C4" with "Combobox1" and Combobox1, but neither worked. I also tried replacing with "B20" - an unlocked cell in my worksheet and it didn't open to that cell. Also tried replacing "Worksheet" with "Sheet11" - the name assigned to that sheet, and that didn't work. Any other clues?

OK, that didn't seem to work either. I'm new at this and must be doing something wrong.
I've attached a sample file below so you can see what I'm trying to do. I want the OrderForm worksheet to open with the cursor in the ClinicianName combobox which will eventually overlay the drill down at D4. That way the user can just start typing the name and then TAB or ENTER to exit the box, moving to D5.

Clinician Order Form - test.xlsm

I'm very gracious for any help that can be provided.

Thanks John, but it still didn't work. Were you able to get it to open in the combobox? Mine just opens in the cell where I last saved it. And yes, I am saving then closing all of the way out and then re-opening. Any other tips?

Chris

That worked! The drilldown now shows on the combobox. I see you opened another window to enter the code. Do you need to open a new window for each type of code? You probably saw that I had a few things running there.

The other step is to have it jump into Description1 (combobox) when TAB/ENTER out of D16.

Can you also recommend a good site where I can learn some of this basic coding language?

Thanks for your help. I've been working on this for a few days now.


Chris