Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Word
application.errors
conversions
docmanagement
drawing.graphics
formatting.longdocs
international
internet.assistant
mail
mailmerge.fields
menustoolbars
newusers
numbering
oleinterop
pagelayout
printingfonts
setup.networking
spelling.grammar
tables
vba.addins
vba.beginners
vba.customization
vba.general
vba.userforms
web.authoring
word6-7macros
word97vba
  
 
date: Thu, 13 Mar 2008 09:35:01 -0700 (PDT),    group: microsoft.public.word.vba.beginners        back       


Insert Text dependant on checkbox behavior`   
Hi All.

I am very new to VBA (extremely) and would like to achive the
following:

Checkbox 1 - Remediated
Checkbox 2 - Accept
Checkbox 3 - Continue


If the user selects (ticks) checkbox 1: I need a certain paragraph
(paragraph1) to be added below the checkbox and remove the other
checkboxes.

The same to happen if I select the other checkboxes.

Example:

Checkbox 1 - Remediated (checked)

The following pending items were remediated:

Item 1
Item 2
Item 3

Signature Line: ______________________________
Date:____________________

{End example}

Is this possible? Do I use bookmarks to insert the text or auto text,
do i even need a vba script or just a macro will suffice.

Any help would be appreciated
date: Thu, 13 Mar 2008 09:35:01 -0700 (PDT)   author:   unknown

Re: Insert Text dependant on checkbox behavior`   
Many possibilities.  Are these formfields (inserted with the Forms toolbar),
or ActiveX checkboxes (inserted with the Controls toolbar)?

Have you considered not using three checkboxes, but one dropdown?  The users
selects one of the three choices, and you go on from there?

But yes, it is possible.  If the text to be inserted is standard, then
AutroText would work fine.

vik.sinha@gmail.com wrote:
>Hi All.
>
>I am very new to VBA (extremely) and would like to achive the
>following:
>
>Checkbox 1 - Remediated
>Checkbox 2 - Accept
>Checkbox 3 - Continue
>
>If the user selects (ticks) checkbox 1: I need a certain paragraph
>(paragraph1) to be added below the checkbox and remove the other
>checkboxes.
>
>The same to happen if I select the other checkboxes.
>
>Example:
>
>Checkbox 1 - Remediated (checked)
>
>The following pending items were remediated:
>
>Item 1
>Item 2
>Item 3
>
>Signature Line: ______________________________
>Date:____________________
>
>{End example}
>
>Is this possible? Do I use bookmarks to insert the text or auto text,
>do i even need a vba script or just a macro will suffice.
>
>Any help would be appreciated

-- 
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/200803/1
date: Thu, 13 Mar 2008 18:33:39 GMT   author:   fumei via OfficeKB.com u37563@uwe

Re: Insert Text dependant on checkbox behavior`   
Thanks for the reply.

Currently they checkboxes are from Control toolbar. I could use a drop
down menu if this makes coding easier.

As far as auto text, I messed around with it but perhaps I am not
doing it correctly. I thought auto text does only single line or text
such as "confidential, personal" etc. And not a formatted paragraph?

I tried this with a bookmark but the bookmark text is always visible:

Private Sub CheckBox2_Click()
    Selection.Collapse Direction:=wdCollapseEnd
    Selection.FormattedText = ActiveDocument.Bookmarks("accept").Range
    'Selection.FormattedText = ActiveDocument.Tables(Table 1).Range
 End Sub

Thanks Again,

On Mar 13, 2:33 pm, "fumei via OfficeKB.com" <u37563@uwe> wrote:
> Many possibilities.  Are these formfields (inserted with the Forms toolbar),
> or ActiveX checkboxes (inserted with the Controls toolbar)?
>
> Have you considered not using three checkboxes, but one dropdown?  The users
> selects one of the three choices, and you go on from there?
>
> But yes, it is possible.  If the text to be inserted is standard, then
> AutroText would work fine.
>
>
>
>
>
> vik.si...@gmail.com wrote:
> >Hi All.
>
> >I am very new to VBA (extremely) and would like to achive the
> >following:
>
> >Checkbox 1 - Remediated
> >Checkbox 2 - Accept
> >Checkbox 3 - Continue
>
> >If the user selects (ticks) checkbox 1: I need a certain paragraph
> >(paragraph1) to be added below the checkbox and remove the other
> >checkboxes.
>
> >The same to happen if I select the other checkboxes.
>
> >Example:
>
> >Checkbox 1 - Remediated (checked)
>
> >The following pending items were remediated:
>
> >Item 1
> >Item 2
> >Item 3
>
> >Signature Line: ______________________________
> >Date:____________________
>
> >{End example}
>
> >Is this possible? Do I use bookmarks to insert the text or auto text,
> >do i even need a vba script or just a macro will suffice.
>
> >Any help would be appreciated
>
> --
> Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/word-programming/200803/1- Hide quoted text -
>
> - Show quoted text -
date: Fri, 14 Mar 2008 11:10:34 -0700 (PDT)   author:   n/a

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us