ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Labell Height (https://www.excelbanter.com/excel-programming/420228-labell-height.html)

kirkm[_8_]

Labell Height
 
Is it possible to calculate the Height value
for a label, depanding on contents ?

I've been counting the number of lines by

frmSerial.Label1.Height = ((CountCR(frmSerial.Label1)) * 10) + 10

Where 10 is font size + 2.

It sort of works but isn't 100%, especially when there's line wrap.

Is there a better way ?

Thanks - Kirk

JLGWhiz

Labell Height
 
Just set autosize to True in the properties window.

"kirkm" wrote:

Is it possible to calculate the Height value
for a label, depanding on contents ?

I've been counting the number of lines by

frmSerial.Label1.Height = ((CountCR(frmSerial.Label1)) * 10) + 10

Where 10 is font size + 2.

It sort of works but isn't 100%, especially when there's line wrap.

Is there a better way ?

Thanks - Kirk



All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com