How can I put an if then statement for a text box? I want an if then
statement to make a text box appear if it meets certain conditions, but with
out using VB. I know you can write formulas for objects, but have never done
it myself. Thanks

As I know no function/formula can change anything in Excel itself, it only
returns a value.
So, if you want to work with the object (show/hide), I am afraid you must
use macro.

--
Best regards,
---
Yongjun CHEN

=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================
"Mike" wrote in message
...
How can I put an if then statement for a text box? I want an if then
statement to make a text box appear if it meets certain conditions, but
with
out using VB. I know you can write formulas for objects, but have never
done
it myself. Thanks