Hi,
trying to make SW VBA macro to call UserForm1 from Sub main(), and during initialization of the form I am pulling data from excel file into combo box in the form. However, I always get only form to show up but without any data within combo box. Trying to locate where the issue is, so I inserted couple message boxes within macro and I do receive message box from Sub main, but nothing from UserForm1_Initialize().
Does anyone have any idea why user form creates an issue?
Just to mention, very same macro I made in Visual Basic Net and works without any issue.
Please check the photo for clearer picture of what I am talking about.
Thanks,
trying to make SW VBA macro to call UserForm1 from Sub main(), and during initialization of the form I am pulling data from excel file into combo box in the form. However, I always get only form to show up but without any data within combo box. Trying to locate where the issue is, so I inserted couple message boxes within macro and I do receive message box from Sub main, but nothing from UserForm1_Initialize().
Does anyone have any idea why user form creates an issue?
Just to mention, very same macro I made in Visual Basic Net and works without any issue.
Please check the photo for clearer picture of what I am talking about.
Thanks,