I noted that the textbox in your example is different to mine. i.e. The
textbox I use is a floating textbox from drawing toolbar, not from control
tool box used in your example. So is your coding still applicable in my case?

"galimi" wrote:

Goto http://www.helpexcel.com/examples

You will see your spreadsheet in the list
--
http://HelpExcel.com




"Sam Kuo" wrote:

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