+ Reply to Thread
Results 1 to 3 of 3

resize label on userform based on filled text

  1. #1
    Forum Contributor
    Join Date
    11-14-2021
    Location
    africa
    MS-Off Ver
    2016 & 2019
    Posts
    255

    resize label on userform based on filled text

    Hi
    is there any procedure to put in userform module to resize lable automatically based and how size of text into label instead of set size manually every time like fit ?
    the lable should expand and shrink based on size of the text inside it .
    when write number in textbox 1 will fill by word in lable1 . I don't want move to new line inside the lable when the words are much . I want resize the lable1 automatically like fit based on size words inside rthe lable1
    also posted in here https://www.mrexcel.com/board/thread.../#post-5931348
    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: resize label on userform based on filled text

    Just set the label properties to Autosize = True and WordWrap = False in the properties window.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    11-14-2021
    Location
    africa
    MS-Off Ver
    2016 & 2019
    Posts
    255

    Re: resize label on userform based on filled text

    thanks very much

+ 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. Update UserForm label text based on dropdown and formula
    By jamiem4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2021, 12:48 PM
  2. [SOLVED] Userform DropDown Filled based on Entry
    By JessCCG in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-03-2021, 05:38 PM
  3. [SOLVED] Move text from label of userform
    By Immortal2014 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2018, 03:40 AM
  4. [SOLVED] Updating Label in Userform as Text Box Changes
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-01-2015, 11:50 AM
  5. Change Label Top on UserForm based on Count
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2012, 12:46 PM
  6. Y-Axis Label won't let me resize it
    By D. Bishop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-20-2005, 12:05 AM
  7. [SOLVED] Userform - Formating Text in a Label
    By TEB2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2005, 05:06 PM

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