Code specifically for CombBox auto population

ZIXILPLIX · 05-03-2010, 07:53 PM

I need a code for ComboBox1 that will populate the ComboBox in a UserForm with the following entries "Brakes, Steering, Engine, Inspection, Overhaul, Electrical and Wheel & Tire." I want to make sure the code is not written for the initialization for the UserForm but written specifically for ComboBox1.

Any help would be greatly appreciated.

**davesexcel** · 05-03-2010, 07:56 PM

If you don't want it to populate when the UserForm shows, when do you want it to populate?

ZIXILPLIX · 05-03-2010, 10:33 PM

I do want if to populate when the form shows, but I want the code written in the ComboBox itself and not the UserForm if that makes sense. In other words, not like this...

Please Login or Register  to view this content.

**davesexcel** · 05-03-2010, 10:41 PM

I have no idea what the difference is...

ZIXILPLIX · 05-03-2010, 11:31 PM

Maybe there isn't a difference, I don't know much about VB programming yet. I was thinking that if the ComboBox was populated in the ComboBox itself, it would be easier to direct that ComboBox to place the selection into a particular cell when a CommandButton on the UserForm is executed. But like I said I really don't know enough to say either way. Either way, I appreciate very much your help.