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

Thanks

Greg

No.


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


"Greg" wrote in message
...
Is there any way to centre the writing on a caption on a
userform?

Thanks

Greg

Thanks Chip

Greg
"Chip Pearson" wrote in message
...
No.


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


"Greg" wrote in message
...
Is there any way to centre the writing on a caption on a userform?

Thanks

Greg

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" wrote in message
...
Is there any way to centre the writing on a caption on a userform?

Thanks

Greg