Alingment of word in a text box to 90 degree angle

**ebin charles** · 05-31-2010, 08:31 AM

Hey I am using userform to enter the details of employees.
In that form I need to make various text box, when I made i can see the word in textbox
is 0 degree which we can read from left to right.

But i need as i shown in picture i attached. it should be 90 degree to read from bottom to top.

Can u help me please in this regard.

Thanks
Charles

**teylyn** · 05-31-2010, 09:19 AM

Hello Charles,

As far as I know, textboxes in UserForms can not be rotated, nor can the text therein be angled in any way.

**ebin charles** · 05-31-2010, 09:22 AM

Thank you sir.

I really miss that format.

thank you

Charles

**ebin charles** · 05-31-2010, 09:35 AM

Sir

Can I get at least in the format I attached.

Is there any idea to make my textbox to look like how my attached image shows.

Please help me.

Charles

**Marcol** · 05-31-2010, 10:03 AM

Just size it to a vertical based shape as you have shown.

Then set the Wordwrap property to True
and set Autosize to False

It is by no means clever, it's a bit hit or miss depending on the letter combinations in the string, like a wide letter being followed by two narrow ones.

Just make the box narrower until you get an acceptable result.

To separate words you will have to use " - " spaces are not recognised by Wordwrap

Therefore "Saudi Arabian" has to be "Saudi - Arabian"

As I said
It's not pretty, and it is not ugly, it's just pretty ugly!!

Cheers.

**Andy Pope** · 05-31-2010, 10:12 AM

Do you really need textboxes or would a label do?

If you take Marcol's suggestion and and a LF between each character you will get the stacked text.

If you can make do with labels or in fact pictures then you maybe able to use the approach I show in this workbook.
http://www.andypope.info/vba/userformdraw.htm