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 / Word / Programming / October 2006

Tip: Looking for answers? Try searching our database.

Userform button?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ithaca - 15 Oct 2006 16:25 GMT
I'm trying to create a custom button to call a macro that runs via userform
but have been unsuccessful.  I can create a button to call the related macro
but I need the actual userform to be called.  is there a way to do this?

Also, is there a way to distribute this button to others that may need it?  
Or will I have to create it on each computer individually?

Thanks in advance for any help!

-Ithaca
JCNZ - 20 Oct 2006 06:56 GMT
Hi Ithaca:

Get the custom button to call a macro to load the form:

Sub Loader()
  Load Userform1
  Userform1.Show
End Sub

If you store the toolbar with the button in a template, then everyone who
accesses the template will see the button.

Cheers.

> I'm trying to create a custom button to call a macro that runs via userform
> but have been unsuccessful.  I can create a button to call the related macro
[quoted text clipped - 6 lines]
>
> -Ithaca
 
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.