Thanks galimi, but the web page
(http://www.HelpExcel.com/examples/hideTb.xls) seems no longer exist??

"galimi" wrote:

Sam,

I have provided an example at http://www.HelpExcel.com/examples/hideTb.xls
--
http://HelpExcel.com




"Sam Kuo" wrote:

Hi, I'd like to hide/show a textbox depending on the value of a cell. How can
I do this?

e.g.
A1="show TextBox1"
A2="hide TextBox1"
B1 is a dropdown list, containing values of A1 and A2 using data validation.
I'd like to hide TextBox1 when B1=A1, and hide when B1=A2. How??

Your help would be much appreciated