View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jerry Price Jerry Price is offline
external usenet poster
 
Posts: 4
Default 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 ~~~