Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
just wondering what the 'correct' way to initialize and dispose of a userform is. presently i am doing something like this: private sub UserForm_Initialize() ' clear contents of combo boxes, label captions, etc ' set up initial values of the above end sub public sub init(optional arg as variant) UserForm_Initialize 'any other code to run here / sub calls MyForm.show end sub private sub myButton_clicked() MyForm.hide end sub and externally (from another module) MyForm.init() is there a better (more correct) way to do this? tia J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create UserForm programmatically | Excel Programming | |||
dynamically create userform | Excel Programming | |||
userform create | Excel Programming | |||
How to create a dynamic Userform via VBA | Excel Programming | |||
Create and show UserForm from Add-In | Excel Programming |