Consulting

Results 1 to 3 of 3

Thread: Text in a Triangle Drawing Object

  1. #1
    VBAX Newbie
    Joined
    Oct 2007
    Posts
    2
    Location

    Text in a Triangle Drawing Object


    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

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    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.

  3. #3
    VBAX Newbie
    Joined
    Oct 2007
    Posts
    2
    Location

    Solved - Text in a Triangle orientation

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •