A Given TextBox to Appear When a Cell Displays a Specific Value

[tommyg2403]

Hi All,

I am making a problem solver where operators tick certain tick boxes and i want a text box to appear with specific help instructions.
I have generated a cell which will return a specific value based on what process variables are ticked.
I want to make a text box visible when a certain number is displayed in a given cell to give the operator help instructions.
I will have about 20-30 different numbers to be generated and need them all linked to a given cell when their number is generated.
I have been struggling to generate a code which makes the text box visible/invisible when that required number is in a cell.

Many thanks for any assistance!

Cheers,
Tom

[torachan]

Big yellow banner at the head of the page - how to upload a workbook.
Help us to help you - far easier to envisage with the actual article at hand.

[tommyg2403]

Hi, Thanks for your response. I cant upload the file itself as my company has a policy against this.
Simply, If the number 1 appears in cell A1, i want TextBox1 to appear. If there is no number in that cell, Make Textbox 1 invisible
Thanks for the help!

[Andy Pope]

UDF (UserDefinedFunction) added to a code module

Please Login or Register  to view this content.

Formula in A2
=ShowTextbox("Textbox 1",A1=1)

The formula uses the name of the textbox to affect and the state of visibility


Any reason why you can not simply use a formula or Conditional formatting to reveal text within a cell? No VBA would be required then