Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I sum up several check boxes conditioned by a combo box? | Excel Discussion (Misc queries) | |||
Combo/List Box and Check Box | Excel Discussion (Misc queries) | |||
create a macro for a combo box to change a pivot table | Excel Programming | |||
Combo Box - Hide Combo Box w/Check Box | Excel Programming | |||
Using a Macro with a check box to Change a cell color | Excel Programming |