Reply to thread

Message: [QUOTE="GS, post: 6453071"] Whenever you attempt to reference a Form it will load if it is not alrady As you can see by my previous post, I've gotten used to using Load/Unload events with forms since using COM and VB6. As Dave aptly points out, the Initialize event fires whenever a form is referenced. In VB6, the Load event doesn't fire unless you execute it in code. Either way, being a Rob Bovey student I've grown accustomed to using object variables when creating instances of a form/userform because that's what's exampled in most his books. Referencing the variable has different behavior than referencing a VBA userform directly is the lesson I've learned from Dave's suggestion. The problem lies where there's code in the Initialize event, which I rarely use in VB6 projects. Just another interesting difference between VB6 and VBA... <g> [/QUOTE]