UserForm Initialize Problem

DeathSurfer

New Member
Joined
Mar 21, 2007
Messages
15
Duuuuudes:

Is there a way to check if a userform, created with vba, running inside of Excel 03' is visible without the userforms initialize event running?

Thanks.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Block comment out your Initialize code and open the userform with code similar to this:
Code:
UserForm1.Show
 

DeathSurfer

New Member
Joined
Mar 21, 2007
Messages
15
Thanks for the reply Dat, the thing is, is I have alot of code in my initialize event that fills out alot of things on my form, so I would have to create alot of sub-routines out of that code. Which is fine and probably should have done that in the first place, I was just looking for another solution other than doing that. A guy on another board posted an idea I didn't think of. He used the "findwindow" windows api call and looked for the caption of the window. I thought that was a cool way of solving this. Anyway thanks for the help.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,535
Messages
5,602,217
Members
414,513
Latest member
junbuggle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top