Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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
Posted to microsoft.public.word.newusers
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForms | New Users | |||
Two questions about Word UserForms | Microsoft Word Help | |||
VBA Marco and disable Userforms on Reopen | Microsoft Word Help | |||
Lost code and non functioning userforms in a workgroup template... | Microsoft Word Help | |||
UserForms: CommandButton Help | Microsoft Word Help |