Hide Textbox1 off if then condition

[Rocky2013]

hello,
I need a VBA to hide a textbox 1 pending on the below condition.
if A1 = "Wrong Entry", texbox1 is unhiden
if A1 = ""; textbox is hideden

A1 has a formula, = if(B1<>"data", "wrong entry","") to check B1 = data

Thanks

[6StringJazzer]

This code goes into the worksheet module. I assume TextBox1 is an ActiveX textbox.

Please Login or Register  to view this content.

[Rocky2013]

Hi,
Popup error message "Run-time error '424' object required.
Textbox 1 does not hide when A1="". I change the name to Textbox1 (without a space), same error.

Thanks

[6StringJazzer]

Unfortunately there are three kinds of objects that Excel calls "textbox". I assumed it was an ActiveX textbox but your object is a drawing object textbox.

The correct code for the file you attached is

Please Login or Register  to view this content.

[Rocky2013]

It works now. Thanks

[6StringJazzer]

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!