Group:  Microsoft Word ยป microsoft.public.word.newusers
Thread: UserForms

Geek News

UserForms
Pepper 10/17/2008 6:02:01 PM
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
Re: UserForms
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/17/2008 8:02:47 PM
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" <Pepper[ at ]discussions.microsoft.com> wrote in message
news:324C0CB5-689F-44A2-87C1-B06D23445F4C[ at ]microsoft.com...
[Quoted Text]
> 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


Re: UserForms
Pepper 10/18/2008 12:01:01 AM
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:

[Quoted Text]
> 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" <Pepper[ at ]discussions.microsoft.com> wrote in message
> news:324C0CB5-689F-44A2-87C1-B06D23445F4C[ at ]microsoft.com...
> > 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
>
>
>
Re: UserForms
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/18/2008 8:49:57 AM
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" <Pepper[ at ]discussions.microsoft.com> wrote in message
news:A139AB05-CF9E-46B8-80A4-388D35996223[ at ]microsoft.com...
[Quoted Text]
> 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" <Pepper[ at ]discussions.microsoft.com> wrote in message
>> news:324C0CB5-689F-44A2-87C1-B06D23445F4C[ at ]microsoft.com...
>> > 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
>>
>>
>>


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net