There are posts everywhere about this but non have a code that works. The most I got was some code to make the form and the controls invisible.
If I could put the controls without a form I wouldn't even need this but I can't, so, how do I do it?
There are posts everywhere about this but non have a code that works. The most I got was some code to make the form and the controls invisible.
If I could put the controls without a form I wouldn't even need this but I can't, so, how do I do it?
I can't make any sense of this question. What do you want to do?
I wanna have a invisible UserForm so that the only thing the user can see is the controls (buttons, mutipages, wharever). Got it?
You don't, at least not with VBA userforms and controls.
It is possible but it's a little complicated. There is no built-in transparency for UserForms. You have to make Windows API calls to directly modify the Window.
I have tried the code at this link and it seems to work but it is not my code, I can't support it, and I can't vouch for how it will behave in different circumstances.
I'm not sure if I put the first code on a Class Module called CFormSkin and the other code on the UserForm's code. I tried that way and it gave me error in the Me.cmdExit
I'm using Microsoft Office Excel 2007.
You have the code in the right place.
cmdExit is the name of a CommandButton on the form that is intended to cancel the operation of the form. The more conventional label is Cancel. You probably have such a button--modify this line of code to use the name of your actual button.
Well, it worked. It takes a little to show the controls and the cmdExit commandbutton turns yellow but it worked. Thanks!
For any other viewers: Insert a Class Module and name it CFormSkin. Then insert a UserForm with a CommandButton named cmdExit. Add the big code to the Class Module and the small code (at the end of the link 6StringJazzer gave) to the UserForm.
I guess this is what makes it take a little:and I noticed the color![]()
Please Login or Register to view this content.
is kind of the transparency key.![]()
Please Login or Register to view this content.
Last edited by rdrmdr; 05-06-2016 at 05:04 AM.
Hi, rdrmdr user!
please post the workbook with your new code of skins working?
thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks