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

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=47256

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.

--
- K Dales


"davidm" wrote:


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

TIA


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=472568

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

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=47256