PDA

View Full Version : Solved: Change Check box Value to Text



MLI
03-16-2009, 09:37 PM
I have a few Checkboxes on a form that populate cells on a excel sheet when selected. I would like to populate the cells with "" when Checkbox Value is "False" (Not Checked) and "Yes" when Checkbox Value is "True" (Checked)

Bob Phillips
03-17-2009, 02:06 AM
With Worksheets("Sheet1").Range("A1")

If Me.CheckBox1.Value Then

.Value = "Yes"
Else

.Value = ""
End If
End With

MLI
03-23-2009, 12:05 AM
Thanks XLD, much appreciated.