comboboxes in user form aren't init at the first Initialize

**Maverick0174** · 10-22-2019, 01:59 AM

Hello together,
I've a user form which has 2 comboboxes. One with adItems and one with list range. Both aren't filled when i start the form.
My OK Button, which print the fields into the sheet, calls also the UserForm to initialize agian (to have an empty form again).
Once i clicked the OK button, the combo boxes are loaded with the correct information. Idk whether i can actually point understandable to my issue.
The Point is, the second init after i clicked OK button works, but for my understanding nothing different happen in the first init.

Capture.JPG

Next Pic shows the combobox after i clicked either OK Button or Clear Button
Capture111.JPG

Here's the Code:

Please Login or Register  to view this content.

Does anyone has an idea?

**bakerman2** · 10-22-2019, 02:40 AM

This should do the trick.

Please Login or Register  to view this content.

**Maverick0174** · 10-22-2019, 03:22 AM

bakerman2,
It does. Thank you

Since I'm not that expert in vba (obviously), could you explain the difference?

Andi

**bakerman2** · 10-22-2019, 03:26 AM

Userform_Initialize is a standard procedure for EVERY userform, regardless the name of the form.

**Maverick0174** · 10-22-2019, 03:38 AM

Understood this but why it works after click the OK-Button? Here was also called Userform1_Init.... ?

**bakerman2** · 10-22-2019, 03:54 AM

That's because you call the Userform1_initialize sub (which is the correct name) but it's only the Userform_Initialize event (without the 1) which fires automatically on opening any form.

Userform1_initialize is just seen as a regular procedure, not as a Userform event code.

**Maverick0174** · 10-22-2019, 05:20 AM

Ok, got it. Thank you very much for the hint and the explanation.

**bakerman2** · 10-22-2019, 07:11 AM

You're welcome and thanks for rep+.

comboboxes in user form aren't init at the first Initialize

LinkBack

Thread Tools

Rate This Thread

Display

comboboxes in user form aren't init at the first Initialize

Re: comboboxes in user form aren't init at the first Initialize

Re: comboboxes in user form aren't init at the first Initialize

Re: comboboxes in user form aren't init at the first Initialize

Re: comboboxes in user form aren't init at the first Initialize

Re: comboboxes in user form aren't init at the first Initialize

Re: comboboxes in user form aren't init at the first Initialize

Re: comboboxes in user form aren't init at the first Initialize

Thread Information

Users Browsing this Thread

Similar Threads

Simple User form initialize and close

User form on initialize to recall last entry from Excel Sheet

[SOLVED] Calling User form Initialize: A way to display certain tab based on which sub called?

Calling a user form initialize sub when entering the form to populate combobox...

named range to populate default textbox value in User form-initialize

User Form Initialize Event Issues

Closing user form in Initialize macro?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions