Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The menu bar is not visible & right click doesnt work | Excel Discussion (Misc queries) | |||
no worksheets are visible when I open a file by a right click | Excel Programming | |||
Items Added to Right-Click Menu Only Visible From Some Sheets | Excel Programming | |||
Items Added to Right-Click Menu Only Visible From Some Sheets | Excel Programming | |||
Toggle Text in a column to be visible or not visible | Excel Programming |