How to hide textbox on userform and unhide it by check box?
I've tried to use that code
I can't hide textbox7 by defaults...Please Login or Register to view this content.
How to hide textbox on userform and unhide it by check box?
I've tried to use that code
I can't hide textbox7 by defaults...Please Login or Register to view this content.
Put thisin the Initialize eventPlease Login or Register to view this content.
I'm assuming this is all in Userform1. Try the Checkbox1_click event to be Me.Textbox7.visible = me.Checkbox1.value
Then in the Userform1_initialize put me.textbox7.visible = False. You might also want to take out the Textbox7_change event. As you have it currently if you type in that textbox (make a change) then it will immediately become not visible.
Thank you. This works.
When I tick checkbox the textbox appears as it should be, when I untick it, texbox7 still appears(unhidden). How to make the appearence dependable on check box?Please Login or Register to view this content.
Edit. runfunke answer solved the problem
Last edited by Alex009988; 07-17-2019 at 12:09 PM.
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks