In Visual Basic proper (not VBA), the property you would use is TextWidth.
That seems not to be available in Excel VBA or Word VBA, either.

IIRC, one suggestion is to put the text in a cell in a column that is
otherwise empty, then AutoFit the column and determine the width. That's a
real kludge, and would probably be slow, also.

On Sun, 24 Oct 2004 03:19:07 +0200, "Seb" wrote:

Hello,

I am merging documents with fields from an Excel sheet.
I need to put some text (from Excel) into boxes pre-printed on the paper,
the boxes have fixed sizes.

The problem is that some datas in the Excel sheet doesn't fit in the boxes,
and because I am using non-fixed fonts the values of the datas are changing
the width of the text (MMMMM vs IIIII).

My goal is to do a macro (in Excel or Word) to tell me which records doesn't
fit in a XX centimeters box when using a specific font/size (and then I can
modify manually the datas in Excel when it's too large).

I searched how to get the real printed width (or any value with a fixed
ratio value/real_printed_width) of a string but I can't find any information
about it.

Thank you VERY VERY much in advance, ANY help is REALLY appreciated.
Seb.

PS: sorry for my bad English, it is not my first language.