View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Turn Check box on?

I have a check box which I would like to turn on... or not turn off in some
code that I previously had turning off all check boxes in the sheet. Here is
the code.

With ActiveSheet
..CheckBoxes = False
End With
ActiveSheet.CBX_R3 = True
ActiveSheet.CBX_R4 = True

is it possible I have the checkbox name's wrong?

Thanks for your help!