Hello, I have this function that stopped working when I added the line "If ctrl.Visible = True Then".
the function checks all controls on a userform to see if it is filled. I have a bunch of them invisible depending on user selection in another combobox. I need the function to ignore those hidden ones because they won't be filled.
can someone please help me fix it? Thanks in advance!
Please Login or Register to view this content.
Last edited by lynnsong986; 10-16-2020 at 01:41 PM.
How aboutPlease Login or Register to view this content.
oh I see. works perfectly now! Thank you so much Fluff13!!
You're welcome & thanks for the feedback.
Try this:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks