Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRYING FIGURE out how wide a text box should be in userform
I am trying to create a form programically.
I have different varying lenth of fields. I am sure there has to be a way to calculate the width of the field, based on the font size and the number of characters. Any ideas how to figure the width? Thanks Bruce |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRYING FIGURE out how wide a text box should be in userform
Did you want the width of the TextBox to vary with the user's entry? If so,
set the AutoSize property to True. -- Rick (MVP - Excel) "Bruce" wrote in message ... I am trying to create a form programically. I have different varying lenth of fields. I am sure there has to be a way to calculate the width of the field, based on the font size and the number of characters. Any ideas how to figure the width? Thanks Bruce |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
TRYING FIGURE out how wide a text box should be in userform
They are to be fixed width. I need to figure out the width so that I can
programically build a set of forms. What I want to do is to have all of the definition in a spreadsheet, and for columnA in the form, the eidth would be in starting (left) would be at x position. I know what the length in chars each cell should be. I figure I should be able to calculate for the next column on the form , knowing the starting position, the length of the field and then the FONT SIZE. I would have thought it would be pretty forward, in the following fasion nextrow pos = left +(FONT.SIZE*CHARLEN)+ pad But it does not seem to be very accurate Thanks Bruce "Rick Rothstein" wrote in message ... Did you want the width of the TextBox to vary with the user's entry? If so, set the AutoSize property to True. -- Rick (MVP - Excel) "Bruce" wrote in message ... I am trying to create a form programically. I have different varying lenth of fields. I am sure there has to be a way to calculate the width of the field, based on the font size and the number of characters. Any ideas how to figure the width? Thanks Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
covert figure in to text | Excel Discussion (Misc queries) | |||
printing wide text | Excel Discussion (Misc queries) | |||
Text Too Wide for Cell | Excel Discussion (Misc queries) | |||
TEXT IN CELL, but not too wide | Excel Discussion (Misc queries) | |||
change figure to text | Excel Discussion (Misc queries) |