Think of a form in design mode (when it is not loaded or running) as a
class. You can modify a class at design time but not at run time. When you
are using the designer, you are modifying the *class* programatically like
you would interactively in the IDE.

Once you load "the form," you have created an instance of the class in
memory. You can set a caption using the *run time* properties of the
instance of the class, but the class itself cannot be modified, any more
than you can write code while the code is executing.

If you want to use the designer on form 1, unload all instances of form 1,
"design" it (i.e., modify the class), then load and/or show a new instance
of the modified class.

I hope this finally clears things up.

Bob Kilmer

"lostthought " wrote in message
...
yeah Designer allows you to Change the UserForm using code. Anybody have
any idea why this isn't initializing?


---
Message posted from http://www.ExcelForum.com/