+ Reply to Thread
Results 1 to 4 of 4

Text of shape does not display vertically

  1. #1
    Registered User
    Join Date
    12-06-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    21

    Text of shape does not display vertically

    Hi everyone,

    I got stuck at displaying text of shape vertically. It is quite strange that I can see the text when I click inside the shape. Below is my code. I also attached the file that I am doing. Hope you guys can help me. It is much appreciated.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by gaului; 09-03-2017 at 09:04 AM.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Text of shape does not display vertically

    I suggest you use the macro recorder to get there.
    The code below came directly from the recorder and now the text is vertical and visible

    Please Login or Register  to view this content.
    TextBox.jpg
    Last edited by kev_; 09-02-2017 at 05:45 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    12-06-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Text of shape does not display vertically

    Thank for your help kev_.
    I changed .Orientation = msoTextOrientationUpward and it works perfectly

    Thanks again Kev_

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Text of shape does not display vertically

    You are welcome
    Thanks for marking thread as solved and for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Two way look up and display all results vertically.
    By holli in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2016, 01:41 AM
  2. [SOLVED] How to display many results vertically
    By holli in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-25-2015, 09:49 PM
  3. Mouse Hover over a shape or picture and will display a text message
    By BI Guy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2014, 10:17 AM
  4. Display text box when clicking a shape
    By ACap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2012, 05:55 AM
  5. Display shape data in a text box?
    By abz in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-18-2010, 08:53 PM
  6. Retrieve Shape text when more than 255 characters inside shape
    By Wizz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2009, 10:09 AM
  7. Replies: 2
    Last Post: 02-14-2005, 01:48 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1