Hi
I have a text box that is a fixed height and width, and has 2 lines of text. The text itself is from a cell and is variable, text lengths could be anything from 7 to 40 characters. I need the text to fit either on one line or 2, but for the text to fill the lines depending on how many characters they have. The text box is on a worksheet, not a form.
I have the same scenario, but the text needs to fit a box which is one line only, and be formatted to use a £ symbol to represent a price e.g £39.99
Hope someone can help!
Paul
I have a text box that is a fixed height and width, and has 2 lines of text. The text itself is from a cell and is variable, text lengths could be anything from 7 to 40 characters. I need the text to fit either on one line or 2, but for the text to fill the lines depending on how many characters they have. The text box is on a worksheet, not a form.
I have the same scenario, but the text needs to fit a box which is one line only, and be formatted to use a £ symbol to represent a price e.g £39.99
Hope someone can help!
Paul
