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

Using a Macro to Change the Value of a Check Box or Combo Box
 

Why not set the check box to false?

Userform1.Checkbox1.value = false

If that doesn't work, you'll need to post more of your code for us to help
you out.

"Irfan" wrote:

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

Using a Macro to Change the Value of a Check Box or Combo Box
 

That works perfect!
Thank you so much for your help, I really appreciate it!
Irfan

"JNW" wrote:

Why not set the check box to false?

Userform1.Checkbox1.value = false

If that doesn't work, you'll need to post more of your code for us to help
you out.

"Irfan" wrote:

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