specterunsee
08-22-2008, 06:21 AM
I've searched thoroughly, so please don't flame me if I missed a post answering this. I'm new to VBA and have been working on a rpp calculator etc in excel and now a VBA form in word to type my notes that are close the same every single time. I didn't like mail merge as much since its extra steps, wheras my form I type in the text boxes, hit execute and it in the background builds the string, and cuts so I can paste. 2 things I'm having trouble finding, which I've found for excel, but not for word....
1. How do I clear all the boxes: I have:
Private Sub resetFormAndCountCalls_Click()
For Each ctl In Me.Controls
If TypeOf ctl Is MSForms.TextBox Then
ctl.Text = ""
End If
Next ctl
txtIBCALL.SetFocus
End Sub
Says error: User defined type not defined. This worked a couple times now it doesn't?!
2. How can I allow other documents to execute WHILE the form is up. I would like to use other macros while form is up for documentation
3. How can hide the document while the form is open.
Basic questions, please give me some help. I've googled this stuff over 4 hours.
1. How do I clear all the boxes: I have:
Private Sub resetFormAndCountCalls_Click()
For Each ctl In Me.Controls
If TypeOf ctl Is MSForms.TextBox Then
ctl.Text = ""
End If
Next ctl
txtIBCALL.SetFocus
End Sub
Says error: User defined type not defined. This worked a couple times now it doesn't?!
2. How can I allow other documents to execute WHILE the form is up. I would like to use other macros while form is up for documentation
3. How can hide the document while the form is open.
Basic questions, please give me some help. I've googled this stuff over 4 hours.