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

S

SallyP

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.
 
C

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
 
S

SallyP

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

Bob Phillips

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