Can I change the color on the TITLE bar of a UserForm?

[gmr4evr1]

Howdy Y'all,

Is there code that would allow me to change the color of a UserForm TITLE bar? I have researched this and haven't found a lot related to it other than using add-ins or 3rd party software. 97% of what I find is about textbox, combobox etc. captions. Using 3rd party software is not an option, add-ins "might be" depending on what the companies IT department will allow.

[karedog]

Hi,

Using WinAPI, you can change the title bar color of ALL WINDOWS (whole system, including the userform), that means, if you change the color of the userform to, lets say red, then all other windows title bar is also changed to red. You can use trick to save the original color of the system title bar color to a variable, change to new color, and when you close the userform, you restore the original color from the variable, like this :

Userform code :

Please Login or Register  to view this content.

Regards

[gmr4evr1]

Thanks Karedog. I did try a similar code but kept getting errors. I'm assuming it's because I am not using WinAPI???? I am not familiar with WinAPI at all. I'll have to look into it more.

[karedog]

You are welcome Tom. Please let me know if you still get any trouble about it.


Regards

[gmr4evr1]

I will. I do have a quick question...is WinAPI and add in?

[karedog]

Quick answer :
No, WinAPI is not an addin.

Quite long answer :
When windows OS is installed in a computer, there are built in libraries (.dll files) also installed.
These libraries are so important, that almost all programming language call them, directly on indirectly (chained).
When we call one of procedures stored in these .dll files, it is said that we do a WinAPI call (like we call one of subprocedures in an Excel module).
So unlike addin that must be installed in every computer that will use some functions/procedures of the addin, there is nothing to be installed when we call WinAPI functions/procedures, because they are built in with the Windows OS.

More info :
https://en.wikipedia.org/wiki/Windows_API


Regards

[gmr4evr1]

Yea, I could have just looked it up myself huh? Thank you for the explanation and the link.