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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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