Userform Captions

[Greg]

Is there any way to centre the writing on a caption on a userform?

Thanks

Greg

[Chip Pearson]

No.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Greg" <[email protected]> wrote in message
news:[email protected]...
> Is there any way to centre the writing on a caption on a
> userform?
>
> Thanks
>
> Greg
>

[Greg]

Thanks Chip

Greg
"Chip Pearson" <[email protected]> wrote in message
news:[email protected]...
> No.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Greg" <[email protected]> wrote in message
> news:[email protected]...
>> Is there any way to centre the writing on a caption on a userform?
>>
>> Thanks
>>
>> Greg
>>
>
>

[RB Smissaert]

You can sort of by putting the right number of spaces before the caption.
Unfortunately it will never be very accurate as VBA doesn't have the
TextWidth property like
VB has. So you will have to work out some complex calculations and even then
it won't be
precisely centred.

RBS


"Greg" <[email protected]> wrote in message
news:[email protected]...
> Is there any way to centre the writing on a caption on a userform?
>
> Thanks
>
> Greg
>