Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Publisher / Programming / October 2007

Tip: Looking for answers? Try searching our database.

Userform not initializing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
eezzell - 01 Oct 2007 17:53 GMT
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.

I've tried two different macros:

Userform1.show

and

dim form1 as new userform1
form1.show

the result is the same--works from the editor but not directly.
Signature

Computing should be about insight, not numbers or flash.

Ed Bennett - 01 Oct 2007 18:05 GMT
> 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.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.