Not sure what I'm doing wrong. Seems like it should say: When the form initializes and CheckBox1 is True then TextBox1 is not visible...
Please Login or Register to view this content.
Not sure what I'm doing wrong. Seems like it should say: When the form initializes and CheckBox1 is True then TextBox1 is not visible...
Please Login or Register to view this content.
Last edited by Rick-O-Shay; 07-03-2020 at 06:52 PM.
I don't think controls have any value while the form is loading. Try moving your code to the UserForm's Activate event.
By the way, your two lines of code can be replaced by this single line of code...
Please Login or Register to view this content.
Last edited by Rick Rothstein; 07-03-2020 at 05:53 PM.
Hmm, Still no. I'm wondering if it is related to how I built my form. I have my UserForm, with a FrameBox, and my TextBox and CheckBox on top.
Can you post your workbook (remove any sensitive data first though)? If so, read the yellow banner at the top of this forum's window to see how you have to do it.
On the Input Data Button, on the form I built, I just want check boxes to disable the fields.
This appears to be a different question than you originally asked. To so what you are now asking for, you will have to put code in each CheckBox's Click event. Here are the first two such event procedures... you have to do similar for the remaining CheckBoxes (make sure match the CheckBox number to the TextBox number)...
Please Login or Register to view this content.
Ah Perfect! Sorry if I was unclear. I knew I would have to do it for each Checkbox/TextField. Sorry, I'm still stumbling my way around VBA via this forum, you tube, and google searches.
Thank you! Have a great evening.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks