Invisible form, visible controls

[rdrmdr]

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?

[6StringJazzer]

I can't make any sense of this question. What do you want to do?

[rdrmdr]

I wanna have a invisible UserForm so that the only thing the user can see is the controls (buttons, mutipages, wharever). Got it?

[cytop]

You don't, at least not with VBA userforms and controls.

[6StringJazzer]

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.

[rdrmdr]

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.

[6StringJazzer]

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.

[rdrmdr]

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:

Please Login or Register  to view this content.

and I noticed the color

Please Login or Register  to view this content.

is kind of the transparency key.

[doriangrey]

Hi, rdrmdr user!

please post the workbook with your new code of skins working?

thanks!