Using a macro to code a checkbox on click - Help
 

Hello,
I have an Checkbox that I want to do the following:

If checkbox is clicked, then add the text "Under" in Cell V3

**I think this needs "CheckBox.Value", but I cant get my finger on this
one. ANY SUGGESTIONS ON HOW TO CODE THIS ONE?

Thanks,
Rog

Using a macro to code a checkbox on click - Help
 

Rog,

Try this

If CheckBox1.Value = "True" Then
Set C = Range("v3")
C.Select
C.Value = "test"
End If



Rog wrote:

Hello,
I have an Checkbox that I want to do the following:

If checkbox is clicked, then add the text "Under" in Cell V3

**I think this needs "CheckBox.Value", but I cant get my finger on this
one. ANY SUGGESTIONS ON HOW TO CODE THIS ONE?

Thanks,
Rog


--


Jerry

~~~ plz remove "nospam." when replying via e-mail ~~~