Dear all
in my work sheet I need to Hide & Unhide some text box By checking a checkbox
it means if user mark the check box the text box will be appear & if uncheck it the text box will be hidden
could you please help me in this case
thanks in advanced
Last edited by pedjvak; 06-30-2014 at 01:15 AM.
If CheckBox1.Value = False Then
TextBox1.Visible = False
ElseIf CheckBox1.Value = True Then
TextBox1.Visible = True
End If
Hi, jquintana83,
please refer to the Forum Rules and put code-tags aorund when posting procedures or longer samples as requested by Forum Rule #3.
@pedjvak
Thread is a duplicate to http://www.excelforum.com/excel-form...check-box.html.
Please do not post the same question into different subforums as requested by Forum Rule #5.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
thanks Jquintana83
at first I am new in excel so could you plz type your code completly
and in my work sheet I have some text box which linked to the cells in the other sheet(hidden) so in your code how I can named it
it means instead of textbox1 what I can type(the name of group of textboxes)
I attached a sample file
if you could plz fix it in my file
thanks in advanced
Hi pedjvak,
Check the attached file and hope this will help you.
SAMPLE.xlsm
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Actually, it can be written much simpler. No need for If..ElseIf, etc.
Please Login or Register to view this content.
If you are pleased with a member's answer then use the Star icon to rate it.
dear my friend it is not working
Hi,
Check the attachment in post #6.
Regards,
Paresh J
Dear pareshj
I download your file but when open it and then enable the macro suddenly the check box was disappeared
please check your file and advise me
thanks
Hi,
I have checked it. It is working fine at my end. I would suggest you to download the file. Save it on some location on your disk and then try to open it and click enable the content. Then try to check it out.
Regards,
Paresh J
The file attached to the OP is and .xlsx file. All the "controls" are rectangles.
One has to assign a macro to shapes if they are to act like buttons. It will have to be an .xlsm file.
The attached has this code.
Please Login or Register to view this content.
Last edited by mikerickson; 06-30-2014 at 02:42 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks