#1
|
|||
|
|||
Trouble automatically running user form
Userform fully functions when I run it from the run tab in developer but when I open a new document from the template the form doesn't automatically show. I have the form code:
Code:
Option Explicit Private Sub Userform_Initialize() End Sub Private Sub cmdSubmit_Click() Select Case "" Case Me.txtContactName.Value MsgBox "Please fill-in the full name of the contact for the group." Me.txtContactName.SetFocus Exit Sub ….etc (all runs great) Code:
Private Sub Document_New() FRM_room_block.Show End Sub |
#2
|
|||
|
|||
Just to confirm...
The userform is in the template file (not the document). The .Show code in Document_New is in the template file. |
#3
|
|||
|
|||
Both are in the template file and the New Doc references the template file.
|
#4
|
|||
|
|||
Document_New vs ThisDocument_Open
Attached are the 2 different procedures I've tried without success and a screenshot of the Userform code box for ref. Thanks every/anyone.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I'm having trouble creating a Merge using label form and placing a shape in the text | blockie | Mail Merge | 8 | 11-13-2013 11:28 PM |
User Form | placasse47 | Excel Programming | 3 | 08-01-2012 05:57 AM |
Running a Macro in a protected form | yessmarie | Word VBA | 1 | 05-25-2012 12:04 AM |
Controlling Style when a user pastes into a form | Cris0205 | Word | 0 | 08-05-2010 04:33 PM |
Trouble updating a form | TomCaesar | Outlook | 0 | 11-29-2006 10:52 AM |