Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
fee fee is offline
external usenet poster
 
Posts: 15
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 510
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The menu bar is not visible & right click doesnt work Rohit Jain Excel Discussion (Misc queries) 1 April 7th 06 07:41 AM
no worksheets are visible when I open a file by a right click njvbguy Excel Programming 1 September 19th 05 05:29 AM
Items Added to Right-Click Menu Only Visible From Some Sheets Carroll[_2_] Excel Programming 12 August 18th 05 04:18 PM
Items Added to Right-Click Menu Only Visible From Some Sheets Carroll[_2_] Excel Programming 0 August 18th 05 02:02 PM
Toggle Text in a column to be visible or not visible Dave Y[_3_] Excel Programming 4 January 8th 04 08:46 PM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"