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

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

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