Hi
I was wondering if it was possible to have a userform, that you fill the informations in the top, make a search in a workbook and if no hit, then activate the botton of the userform (Hidden/non hidden)
Hi
I was wondering if it was possible to have a userform, that you fill the informations in the top, make a search in a workbook and if no hit, then activate the botton of the userform (Hidden/non hidden)
Last edited by Vibov; 04-05-2022 at 03:55 AM.
You have two options;
-Enable (If set to false, this will have the elements showing, but they will not be interactive until enabled)
-Visible (If set to false, this will physically hide the elements until visibility is set to true)
So change these, you just need to code a line along the likes of;
I would go for Enable as my choice, as Visible will leave you with a lot of empty space on your form, unless you're dynamically changing the dimension of the userform.Please Login or Register to view this content.
You can also play with the size of the UF as on the attached in order to hide the disabled elements.
If things don't change they stay the same
Thanks alot
Hi
I canīt seams to get it to work probaly? On sheet one I have 2 button and the first one are ok,
but the second donīt show the last to field so Iīm albe to fill them? What is missing to be able to fille the last text field and combobox in userform2?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks