Initialize error with multiple Comboboxs & lists

**JamesT1** · 10-01-2008, 04:03 PM

Hi

I have a userform used to insert new vehicle details onto a spreadsheet. below is the code used in two of the boxes to choose the service intervals and the engine type. There is another combobox on the form, however when I try the same type of code for more than 1 box I receive an error on the "Sub Userform_Initialize" line. I assume I need to change something on the 'Sub' line but I cannot figure out what!!!,,, can someone help please

thanks

Please Login or Register  to view this content.

**Trebor76** · 10-01-2008, 08:35 PM

Hi JamesT1,

There are couple of changes needed here.

1. You need to use the ListBox control on your form as the AddItem command isn't applicable for text boxes
2. As there can only be one UserForm_Initialize command on a form, all the events (code) you want to run from its' execution must be entirely within it.

For reference, I've created a dummy form on the attached with the above points worked in.

HTH

Robert