Upside down text with shrink to fit by textbox
Results 1 to 3 of 3

Thread: Upside down text with shrink to fit by textbox
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Upside down text with shrink to fit by textbox

    Hi, I need to invert text in cells up down side and I have found the best way to insert textbox and invert it then linking it to the cell.
    I try to make the text in the textbox to shrink to fit the size of the text box, thanks in advance.

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,745
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Upside down text with shrink to fit by textbox

    Try this:

    to DECREASE font size - click on shape and "OK" (click more than once to keep decreasing)

    to INCREASE font size - click on shape and replace "Y" with any other character (or delete the "Y")


    Assgn this macro to the textbox
    Code:
    Sub TextBox1_Click()
        
    With ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Font
        If UCase(InputBox("Y = decrease", "Font Size", "Y")) = "Y" Then .Size = .Size - 1 Else .Size = .Size + 1
    End With
    
    End Sub

  3. #3
    New Member
    Join Date
    Apr 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Upside down text with shrink to fit by textbox

    Thank you
    The shrink to fit is the most amazing formatting features in excel.
    That makes me make printing programs many times from excels file.

    I think there isn't any way to get this features on textboxs but something like your way.
    Thank you again.
    Last edited by Sami_Noa; Jul 15th, 2019 at 10:12 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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