.additem loading bug on userform

Hi guys, bit of a strange bug in my userform...

• I have 3 combo-boxes on one of my pages (1 of 3) on my userform.
  
• The items in the combo-box are added via '.additem'. There are 36 items split unevenly.
  
• The page with the combo-box is the first page in the userform,
  
• When I load the userform the combo-box items do not load automatically. If I move onto another page and return straight after, the items will have loaded into the combo-boxes.
  
• Interestingly,when I set the non-combo-box page as the first page and call the userform - then move to the combo-box page the items will have loaded into the combo-box.

Ideally, I would like the combo-box page to be the first when the userform is loaded and the items to load immediately into the combo-box.


I havent attached my book, but i can do so on request if you believe it will help (sorry, being lazy to mask all private info.)

Any ideas would be greatly appreciated. Many thanks,
D

We need to see the code to understand the problem, so attach an example workbook

It's not a bug, it's doing exactly what you have coded, i.e. loading the comboboxes on multipage change. The code needs to be in the initialize event of the UserForm, ot MultiPage_Change

Please Login or Register  to view this content.

You can avoid more....
The months have been introduced by Excel itself; use them
If populating multiple item use the method List.(It's also considerably faster).
If using List you don't need the instruction Clear.

This will produce the same result

Please Login or Register  to view this content.