How to format Userform caption?

  • Thread starter Thread starter davidm
  • Start date Start date
D

davidm

Does anyone know how to (via code or otherwise) change the fon
attributes (size, name etc.) of a Userform caption? I have failed wit
several attempts, each time just returning the default settings
Changing the Userform font properties in the Properties Window doesn'
help.

TI
 
The caption on a userform is the titlebar of the window - this is a Windows
property, not unique to the userform. So to change it you would have to
change the Windows setting (via API call) and it would change the setting for
all Windows titlebars - not an advisable thing to do in your code.

If you want it to have a different appearance, you could put a label on the
top of the form - it will not replace the titlebar(which will still be there
and visible) but it can be formatted however you wish.
 
Thanks Dales for your help and explanation, confirming what
half-suspected viz. the need to resort to API call. It would have bee
great if it were possible to format userform titles in a "friendlie
way"; while the use of labels serves the purpose, it sometimes comes a
a cost of eating up precious space and causing clutter. Once again, man
thanks.

Davi
 
Back
Top