Solved: Userform with Check boxes

[TButhe]

Hi I'm back for more help!!

I have a letter that has a few fields in it so for my users I am just giving them a userform to fill in. Most of the data is date, name, date of original communication, etc and I use regular text boxes for that and I know how to do that. However, I have 3 of these where they must make a choice between some of the wording of the letter. I want to put those choices on the userform as check boxes. Whichever box is checked, that text gets inserted into letter at the given bookmark. The problem is I have no idea how to tell VBA to put that info into the letter. I know this will probably be a breeze for you out there but I have searched all over and can't find it. I have probably just missed it somewhere. A line of code or a link to KB article... any help would be appreciated.

[Jacob Hilderbrand]

If a CheckBox is checked, its value is TRUE, otherwise it is FALSE.

So

[vba]
If UserForm1.CheckBox1.Value = True Then
'Add Text To Letter
End If

If UserForm1.CheckBox2...
[/vba]

[TButhe]

That is just what I needed. I can't tell you how much I appreciate it.
Sometimes I feel like I will never get a handle on this

Thanks again for helping. I'll be back so you may want to run now.

Tracy

[Jacob Hilderbrand]

You're Welcome

Take Care