#1   Report Post  
Posted to microsoft.public.word.newusers
pepper pepper is offline
external usenet poster
 
Posts: 27
Default UserForms

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
  #2   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default UserForms

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" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.word.newusers
pepper pepper is offline
external usenet poster
 
Posts: 27
Default UserForms

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" wrote:

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" wrote in message
...
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




  #4   Report Post  
Posted to microsoft.public.word.newusers
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default UserForms

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

"Pepper" wrote in message
...
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" wrote:

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" wrote in message
...
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






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForms Archie New Users 1 August 7th 08 07:43 AM
Two questions about Word UserForms Mark Microsoft Word Help 6 October 30th 06 04:42 PM
VBA Marco and disable Userforms on Reopen AmandaH Microsoft Word Help 3 July 4th 06 07:28 PM
Lost code and non functioning userforms in a workgroup template... joep3 Microsoft Word Help 6 April 18th 06 07:03 PM
UserForms: CommandButton Help Wendy D Microsoft Word Help 2 August 16th 05 09:34 PM


All times are GMT +1. The time now is 11:58 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"