Trouble automatically running user form

Lostinvba · #1 11-22-2013, 10:11 PM

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)

and This Document code simply:

Code:

Private Sub Document_New()
FRM_room_block.Show
End Sub

My form is called "FRM_room_block" obv.

fumei · #2 11-22-2013, 10:47 PM

Just to confirm...

The userform is in the template file (not the document).
The .Show code in Document_New is in the template file.

Lostinvba · #3 11-23-2013, 03:26 PM

Both are in the template file and the New Doc references the template file.

Lostinvba · #4 11-23-2013, 07:22 PM

Attached are the 2 different procedures I've tried without success and a screenshot of the Userform code box for ref. Thanks every/anyone.

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