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" <(E-Mail Removed)> wrote in message
news:1C1A243B-D064-4FF6-93EF-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:1C1A243B-D064-4FF6-93EF-(E-Mail Removed)...
> > 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
>
>
>