And to answer your later questions, no I don't create userforms with code. I use the GUI to create and layout the controls and then heavily customise macros on a lot of those controls to get the functionality I want. I guess I could create and populate the controls via code but that is additional work that isn't required.



I have used code to populate content in labels and controls but only very rarely would I actually create the controls themselves with code. The only time I would do that is when the actual number of controls needed isn't known at design time (ie the code reads data from somewhere that specifies how many controls are needed).

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia