UserForms

[Pepper]

Doug Robbins provided a cool solution to a problem that encompassed using a
UserForm in Word 2003 (see Further Automation from 10/14). I have been able
to implement that with three Bookmarks and a bunch of Cross References.

I do have some on going problems. The problem is an occasional RunTime
Error #424 when the AutoNew macro runs. It doesnt seem to like the command
UserForm1.Show. Any suggestions will be appreciated.

And when I can this to work consistently, I will follow up with asking about
adding some more features to the UserForm. Drop-Downs will be wonderful to
enforce validation

Thanks to PA for posting the question and Doug's inputs.

Pepper

 

[Doug Robbins - Word MVP]

Try giving your form a particular name and then use

Dim myForm As frmMyForm

Set myForm = New frmMyForm
myForm.Show 'vbModal
Unload myForm
Set myForm = Nothing




--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Pepper]

Thank you Doug.
A silly question for your confirmation:
This code is the new code of the autonew macro - Yes?

I guess it is not a really silly question since I only know enough VBA to be
dangerous!

 

[Doug Robbins - Word MVP]

Yes.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP