PDA

View Full Version : [SOLVED] Text in a Triangle Drawing Object



dforgacs
04-05-2012, 10:44 AM
:banghead:
If I place a triangle drawing object on a spreadsheet in excel 2010 and put any text in the triangle and then rotate the triangle up side down I can't change the text orientation to be right side up. You can adjust by 90 or 270 degrees but not 180 degrees. I've tried it manually on the spreadsheet and with vba code in a module, and it seems that it isn't possible. Anyone else had this issue? Help!
Daniel Forgacs

Kenneth Hobs
04-05-2012, 12:07 PM
Welcome to the forum!

That is not an option. Try overlaying an activex textbox control. A drawing tools textbox control can be rotated in any direction. Group your objects if needed.

dforgacs
04-05-2012, 12:28 PM
I was able to find this work around.
Select text inside Triangle and right click on
Format Text Effects
3-D Rotation
adjust Rotation Z: to 180 degrees

And it works. However the text font changes to a 3D effect and looks likes it's bolded, so I guess it's a small price to pay for making the text right side up.
Thanks for confiming my suspicion!
Daniel Forgacs