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.

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.

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.

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.

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.