| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Initialize event doesn't fire reliably
If Userforms.Count Then ' app is running
Sorry, didn't get that one. Yes, I wasn't very clear! I didn't mean to suggest this single line was a substitute for the full code. Rather, for an app that whilst running will always have at least one Userform loaded, if Userforms.Count is zero confirms that the app is not running, otherwise it is. As I said it was a FWIW, not directly related to your needs but a usage of querying the collection for a particular purpose. Regards, Peter T |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Event doesn't fire | Excel Discussion (Misc queries) | |||
| Workbook Open event does not fire | Excel Programming | |||
| Event class doesn't fire in embedded VBA | Excel Programming | |||
| Initialize event doesn't work | Excel Programming | |||
| Generic questions about variable scope the Initialize event | Excel Programming | |||
Threaded Mode
