| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I create a formula in Excel that evaluates form information?
I want to create a conditional formula in Excel that evalutes form data;
specifically, if a checkbox is selected, I want a specific value returned. Is there a way to do that? Thanks for any help anyone can provide. I'm using Excel 2003. |
|
#2
|
|||
|
|||
|
No, Conditional Formatting cannot get information from a
userform. You'd have to have the checkbox in the form write its state to a cell, and then use the value of that cell in your Conditional Formatting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SallyP" wrote in message ... I want to create a conditional formula in Excel that evalutes form data; specifically, if a checkbox is selected, I want a specific value returned. Is there a way to do that? Thanks for any help anyone can provide. I'm using Excel 2003. |
|
#3
|
|||
|
|||
|
I hate to appear ignorant, but how do I have the checkbox write its state to
a cell? "Chip Pearson" wrote: No, Conditional Formatting cannot get information from a userform. You'd have to have the checkbox in the form write its state to a cell, and then use the value of that cell in your Conditional Formatting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SallyP" wrote in message ... I want to create a conditional formula in Excel that evalutes form data; specifically, if a checkbox is selected, I want a specific value returned. Is there a way to do that? Thanks for any help anyone can provide. I'm using Excel 2003. |
|
#4
|
|||
|
|||
|
Set the ControlSource property of the checkbox to the worksheet cell you
want. -- HTH Bob Phillips "SallyP" wrote in message ... I hate to appear ignorant, but how do I have the checkbox write its state to a cell? "Chip Pearson" wrote: No, Conditional Formatting cannot get information from a userform. You'd have to have the checkbox in the form write its state to a cell, and then use the value of that cell in your Conditional Formatting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SallyP" wrote in message ... I want to create a conditional formula in Excel that evalutes form data; specifically, if a checkbox is selected, I want a specific value returned. Is there a way to do that? Thanks for any help anyone can provide. I'm using Excel 2003. |
|
#5
|
|||
|
|||
|
Bob and Chip - Thank you very much.
"Bob Phillips" wrote: Set the ControlSource property of the checkbox to the worksheet cell you want. -- HTH Bob Phillips "SallyP" wrote in message ... I hate to appear ignorant, but how do I have the checkbox write its state to a cell? "Chip Pearson" wrote: No, Conditional Formatting cannot get information from a userform. You'd have to have the checkbox in the form write its state to a cell, and then use the value of that cell in your Conditional Formatting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SallyP" wrote in message ... I want to create a conditional formula in Excel that evalutes form data; specifically, if a checkbox is selected, I want a specific value returned. Is there a way to do that? Thanks for any help anyone can provide. I'm using Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to create specific formula | Excel Worksheet Functions | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
| Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
Linear Mode
