Word Wrap & Print Functions

[insamoufonyx]

Hi all,

I have a user form that i have created for something at work but im stuck on two bits,

1. In one of my boxes on my form it can contain alot of text, is there a way i can get it to word wrap on the form? at current it goes out of the box and stays on one line.

2. In my spreadsheet i have data in rows, so there is a corisponding piece of data to a row in each column,

in one of the columns i have a "plug number" i want to have a button on my form that says "print plug 1A" or " Print Plug 32A" etc that once pressed will print all the rows that have 1A or 32A in the specified column.

are either of these posible? any help appriciated.

Cheers

[Leith Ross]

Hello insamoufonyx,

Most controls on a UserForm have WordWrap property. This a boolean value. Set it to True to have the text wrap around. A Range object on a worksheet also has this property.

Code Examples for WordWrap Property

Please Login or Register  to view this content.

Manually Setting WordWrap for a Cell or Range of Cells

1. Select the cell or cells with the mouse.
2. Right Click on any cell in the selection.
3. Select Format Cells... from the context menu.
4. Click the Alignment tab.
5. Look for the Check Box labeled Wrap Text. Click once to set it and click again to clear it. You can also use the key combination ALT+W to toggle the Check Box.