Text width in pixels

[sapka]

Hello,
I need to get width of text in pixels. I need it for two reasons:
1) to be able to use Data Validation and UDF in a way that user won’t be able to type text which does not fit in the cell
2) to be able to do the same as in (1) but with ~ 50 000 string queries at a time (I will read data from file and so some data validation)

I need some API implementation. I need it to be really fast. I guess it has something to do with GetCharABCWidths.

Can anyone help me?

P.S. This idea have not worked for me.

 

[sapka]

Up!

 

[Legacy 98055]

Try searching "GetTextExtentPoint32 Function" on MSDN.

 

[sapka]

Thanks for advice. However, I cannot make these APIs work for me correctly.
They are either not working or giving wrong results for me.