Can I create a formula in Excel that evaluates form information?

[Guest]

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.

 

[Chip Pearson]

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

 

[Guest]

I hate to appear ignorant, but how do I have the checkbox write its state to
a cell?

 

[Bob Phillips]

Set the ControlSource property of the checkbox to the worksheet cell you
want.

 

[Guest]

Bob and Chip - Thank you very much.

Set the ControlSource property of the checkbox to the worksheet cell you
want.