UserForm Caption Font

I'm starting to get the hang of using UserForms as dialog objects rather than jumping around from workbook to workbook or sheet to sheet when controlling what the user interface is like. Everything is falling into place for the most part. But one minor aspect bothers me and I cannot find a way to control it.

While the prompts and their labels are in size 10 font and bold, the caption of the UserForm remains rather small and not bold. Changing the font property of the UserForm doesn't affect the caption. I've tried to find a property of the UserForm within VBA (as well as another way to reference the form object than by it's name) and have come up short. Since the caption is like a major heading to distinguish one dialog from another, I would like for it to stand out more.

Has anyone ever seen a means whereby the caption font can be controlled? Thank you.

Steve

Hi s_andrews,
Though my knowledge of this is very limited; the Caption of a Userform is a part of its Title Bar (a property of the Windows OS GUI). To modify it, one would have to resort to API calls. Now, whether it is possible to modify one specific instance of a "Title Bar"? I'm not sure.

Nevertheless, here's an alternate approach:

• hide the "Title Bar" or Caption of your Userform using API calls (see here); and
• then position a suitable Label at the top of the Userform to appear as the Caption you require. It is much easier to modify the Label font & background.

HTH. Cheers!
Jewel

+1

a Guru approving my response, ... made my day!
Thanks a ton Sixthsense

Thank you for your responses. I like jewelsharma's second approach of just hiding the caption and inserting a textbox as the label/heading. That gives me complete control of the heading's font (color, size, and style) as well as it's location. But I will hide the caption simply by blanking out the Caption property rather than using API calls as suggested. Thanks again.

Steve

I followed the suggestion but was not satisfied with the fact that the window no longer had a handle allowing the user to relocate it.
I decided to leave the Caption empty and place a Label underneath allowing not only to use any font and size but also adjust the form width. The result looks as follows and I am quite satisfied with it (the small bottom space is managed by an extra empty Label):
Attachment 660162