Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro with user form

Status
Not open for further replies.

mihalj

Mechanical
Apr 15, 2009
40
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,
 
 http://files.engineering.com/getfile.aspx?folder=bb6e82c0-bab9-4d07-ba7a-03de128973e0&file=Capture3.JPG
Status
Not open for further replies.

Part and Inventory Search

Sponsor