CheckBox query

[Adrian]

Hi all,

This is another basic question but I cannot seem to get it
right.

I have created a userform that contains 6 checkboxes.

I want to rig it so that depending on the options chosen
by the user (me!!) a line of text is printed on the active
doc.

I have the code in the CommandButton click

EG
One box is called GIA

So my line of code is

If chkGIA = 1 Then Selection. TypeText "Gia can be found
in Aberdeen"

The code is repeated for the other checkboxes with the
appropriate name and text.

It doesnt seem to work

I have tried If chkGia.Checked= True Then......

That doesnt work either.

Any suggestions as to what I am doing wrong would be
gratefully recieved.

Many thanks
Adrian

 

[Doug Robbins - Word MVP]

Hi Adrian,

Use:

If chkGia.Value = True then etc.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Adrian]

Hi Doug,

I still get a "RunTime error 424 Object required" Message.

What am I missing here?

Thanks for your help.

Adrian

 

[Doug Robbins - Word MVP]

Hi Adrian,

If the box is called Gia and not chkGia, then delete the chk.
-
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[adrian]

Thanks Doug,

Works a treat
I assumed that chk was needed to ID it as a checkbox.
One of the disadvantages of looking at examples to try and
figure out how to do it.

Adrian