populating an independent drop down with VBA

[justinhampton81]

I can't quite tell if this forum is for excel only vba, or if general vba questions can be asked, so I'll ask for forgiveness if it is excel only vba because this relates to a word document I'm working on.

My question is: how does one create a drop down list using vba? I used to use this code for a set of dependent drop downs, but I now only need to populate one drop down list and the code doesn't translate over.

Please Login or Register  to view this content.

[Andy Pope]

the code looks like it's for two dropdowns where the second is populated dependent on first ones choice.
So the above contains all the code you need.

Please Login or Register  to view this content.

you just need to make sure the control name is correct. Then change the text and quantity of .Add items