
Signature
Computing should be about insight, not numbers or flash.
> I have an userform with a listbox control that I am populating with the
> userform_initialize() sub. When I run the macro from the Visual Basic
> editor, everything works just fine, but when I run the macro from the tools
> menu, macro, macros, select the macro, and click run. The userform doesn't
> initialize. If I run the macro by clicking edit to bring up the Visual Basic
> editor and then clicking run it works. I am working in Publisher 2003.
Do you have the latest service pack for Publisher 2003? What elements do
you have on your UserForm? I just tried this with an empty UserForm in
Publisher 2007 and it worked fine.

Signature
Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org
eezzell - 01 Oct 2007 18:32 GMT
Thanks for the quick response. I copied the macro to a blank Word 2003
document and it worked just fine. Then I opened a blank publisher document
and verified that events aren't firing except when I run the macro from the
editor. I'll let you know if a service pack helps.

Signature
> > I have an userform with a listbox control that I am populating with the
> > userform_initialize() sub. When I run the macro from the Visual Basic
[quoted text clipped - 6 lines]
> you have on your UserForm? I just tried this with an empty UserForm in
> Publisher 2007 and it worked fine.