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

I

Irfan

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
 
J

JNW

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top