Change Color of Caption in User form 2007
 

hi - i need to format the caption section of the user form......particularly
change font type, change background color of the caption section and also
center the caption. i would ideally like this to happen during initialize and
so would put the code in Initialize sub.

thanks for your help

Change Color of Caption in User form 2007
 

Those are set through the operating system, not on a per userform basis. You can always use a
textbox for a caption....

--
HTH,
Bernie
MS Excel MVP


"amit" wrote in message
...
hi - i need to format the caption section of the user form......particularly
change font type, change background color of the caption section and also
center the caption. i would ideally like this to happen during initialize and
so would put the code in Initialize sub.

thanks for your help

Change Color of Caption in User form 2007
 

thx Bernie - thats what i thought as well, but just wanted to confirm. thx
for the reply.

"Bernie Deitrick" wrote:

Those are set through the operating system, not on a per userform basis. You can always use a
textbox for a caption....

--
HTH,
Bernie
MS Excel MVP


"amit" wrote in message
...
hi - i need to format the caption section of the user form......particularly
change font type, change background color of the caption section and also
center the caption. i would ideally like this to happen during initialize and
so would put the code in Initialize sub.

thanks for your help