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

I am using a command button on my spreadsheet to call a user form. In the form I need to populate the combobox. I have an "Initialize form sub" to do this which works within the form using a "Clear" button which writes "" to each textbox, and gets the combobox populated, and I don't know how to get it to go when the form is launched. If the user is already in the form and clicks the clear button, it works fine. But entering the form, the combobox is empty... I tried to call the initialize right after the showform but no go...

@regupnorth

Can you upload your workbook?

Here it is.
Click on Add Asset to Shipping List button in spreadsheet and it loads the data entry form... Combobox is not populated. Click "Clear" button in form, which call initialze routine, any existing data in textboxes in form are cleared and the combobox populated...

@regupnorth

add this to your Asset_UserForm module.

Please Login or Register  to view this content.

remove from Command_Button_Assets_Entry_Form_Click

Please Login or Register  to view this content.

Heres the working form.


Shipping Ticket Test Template Uploadver_ver2.xlsm

Thank you for that. I then took that over to another project but I messed it up somewhere. Can you point it out? In the attached file I select the "Enter Assets" button but it doesn't initalize... Frustrating since I thought, since this is basically a smaller version of the original program, it would work... but thats my problem... assuming.

Here this will work for you. the problem was you were not actually using the UserForm_Initialize. So your comboboxes would not populate.

Field Asset Inventory Test Template Uploadver.xlsm