Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set a minimum row height a the same time with autofit row height | New Users to Excel | |||
Row Height stopped growing and Auot-Fit Row Height does not work | Excel Discussion (Misc queries) | |||
the row height should be excatly the height of the data | Excel Discussion (Misc queries) | |||
need to dbl row height without changing height of cell next to it | New Users to Excel | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) |