Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Word XP
I have a vba userform in a template and one of the questions on the form is "One or more classes of shares?" The choices are one of two optionbuttons One or More than one. This is so I can automate the wording in the template to either singular or plural. Optionbuttons: FrmStage2.sharess FrmStage2.sharesp Document/Template: RESOLVED: that the form of share certificate{if frmState2.sharesp = True "s"}and blank ensorsement thereon, etc. Logically I would use the above code but of course it doesn't work. This should automatically add an s to the word certificate. Desperate Brenda |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Where you want either certificate or certificates to appear in the document,
insert a { DOCVARIABLE varcertificate } field and in the userform code, use the following With ActiveDocument If sharess.value = True then .Variables("varcertificate").Value = "certificate" Else .Variables("varcertificate").Value = "certificates" End If .Range.Fields.Update End With -- 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 "Brenda A. Reid" wrote in message ... Word XP I have a vba userform in a template and one of the questions on the form is "One or more classes of shares?" The choices are one of two optionbuttons One or More than one. This is so I can automate the wording in the template to either singular or plural. Optionbuttons: FrmStage2.sharess FrmStage2.sharesp Document/Template: RESOLVED: that the form of share certificate{if frmState2.sharesp = True "s"}and blank ensorsement thereon, etc. Logically I would use the above code but of course it doesn't work. This should automatically add an s to the word certificate. Desperate Brenda |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
which statement right , question is Choose the correct statement? | Microsoft Word Help | |||
which statement right , question isChoose the correct statement? | Microsoft Word Help | |||
using iif statement | Mailmerge | |||
If Then statement | Microsoft Word Help | |||
OR statement | Mailmerge |