View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Irfan Irfan is offline
external usenet poster
 
Posts: 12
Default Using a Macro to Change the Value of a Check Box or Combo Box

Hello There,

I am creating an input screen with different controls such as Combo Boxes,
Check Boxes, etc... I have a Reset Values button which when selected will
make the values of all check boxes false. When the Reset Values button is
selected is runs a macro to do this. My program crashes every time I execute
this macro. It seems like a simple enough thing to do.

I have tried many different ways to make the cell value false. These are
some of the examples I have used:

Range("D7").Select
ActiveCell.Value = False

Range("D7").Select
ActiveCell.FormulaR1C1 = "FALSE"

Range("D7").Value = False

If any one can give me some help on this it would be greatly appreciated.

Thanks,
Irfan