 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / September 2005Macro allowing user to select one of two templates
I need to create a macro that has two option buttons. If the user selects the first option button, a specific template using singular language will run. If the user selects the second option button, a specific template using language for multiple signers will run. Templates don't "run". Are you trying to do anything more than create a new document using one of two possible templates? >I need to create a macro that has two option buttons. > [quoted text clipped - 3 lines] > If the user selects the second option button, a specific template using > language for multiple signers will run. Sorry - my terminology is probably off. I need a macro that would show a user form. The user form would show two option buttons. Depending on which option button was active, one of two templates would kick off. > Templates don't "run". Are you trying to do anything more than create a new > document using one of two possible templates? [quoted text clipped - 6 lines] > > If the user selects the second option button, a specific template using > > language for multiple signers will run. > Sorry - my terminology is probably off. > > I need a macro that would show a user form. The user form would show two > option buttons. Depending on which option button was active, one of two > templates would kick off. Create a UserForm. Put two optionbuttons on it and one CommandButton The OptionButtons will be named OptionButton1 and OptionButton2. Put whatever captions you want on the three buttons. In the Click event of the CommandButton, include the following code If OptionButton1.Value Then Documents.Add Template:="full path of template 1" ElseIf OptionButton2.Value Then Documents.Add Template:="full path of template 2" Else MsgBox "Make sure one of the template options has been selected End If Unload Me Put the correct full pathnames of your two templates in the appropriate places in the code.  SignatureRegards Jonathan West - Word MVP www.intelligentdocuments.co.uk Please reply to the newsgroup Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org |
Reply to this Message |
 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.