ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   text box visible on click (https://www.excelbanter.com/excel-programming/374160-text-box-visible-click.html)

fee

text box visible on click
 
I have created a form, and I would like to know how to have the textbox
hidden, and then if the check box is ticked the textbox appears, so
that the person can enter information to that question.

Could someone please help


Carim

text box visible on click
 
Hi,

Use the following instruction :

TextBox1.Visible = True ' to show text box
TextBox1.Visible = False ' to hide text box

To have these instructions operational, you have to put them in the
click event
of your object
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
TextBox1.Visible = True
End If
End Sub

HTH
Cheers
Carim



All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com