VBA Express Forum  




Go Back   VBA Express Forum > VBA Code & Other Help > Word Help
     Feedback     
Register FAQ Members Arcade Knowledge Base Training Articles Consulting

Reply
 
Thread Tools Display Modes
Old 04-16-2012, 07:18 AM   #1
flohrstw

 
Joined: Apr 2012
Posts: 12
Kb Entries: 0
Articles: 0
Runtime 424 and Compile Error

So I've encountered 2 new errors while trying to run my User Form in Word 2007. The first is "Run-time Error 424 - Object Required" after clicking the Clear command button. The debugger is pointing to the fifth line of code for "txtTest3." If I remove that line, the debugger highlights "End Sub."

Private Sub cmdClear_Click()
txtUserName.Value = Null
txtTest1.Value = Null
txtTest2.Value = Null
txtTest3.Value = Null
End Sub

------------------------------------

The second one says "Compile Error - Invlaid Qualifier." The debugger points to the first line in the code in reference to my submit command button after clicking the submit button:

Private Sub cmdSubmit_Click()
With ActiveDocument
.FormFields("Text1").Result.Text = txtUserName.Value
.FormFields("Text2").Result.Text = txtTest1.Value
.FormFields("Text3").Result.Text = txtTest2.Value
.FormFields("Text4").Result.Text = txtTest1.Value
End With
Application.ScreenUpdating = True
Unload Me
End Sub

Any help would be greatly appreciated.

Local Time: 02:16 PM
Local Date: 05-24-2013
Location:

 
Reply With Quote Top
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -7. The time now is 12:16 PM.


Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright © 2004 - 2012 VBA Express