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

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

I've duplicated your code, but an error occurs with ".TextBox1" being
highlighted saying the object cannot be found. Why is this? I've renamed the
textbox to "TextBox1" already.

Thanks



"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

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