+ Reply to Thread
Results 1 to 3 of 3

Using auto-size with forms - need to size based on text!

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    Waterloo, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    18

    Using auto-size with forms - need to size based on text!

    Hi there, I have a few forms in a spreadsheet that are used as textboxes. I need them to expand based on the amount of text in the box. I've gone into properties of these forms, and made auto-size true, but then when I leave design-mode, the form gets warped and misshaped.

    Does anyone have any tricks to avoid this?

    Thanks for your help!

    TEST_F.xlsm

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Using auto-size with forms - need to size based on text!

    Does it help if you change "WordWrap" to False ????

  3. #3
    Registered User
    Join Date
    04-30-2013
    Location
    Waterloo, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Using auto-size with forms - need to size based on text!

    It did work, but the form still gets warped when I exit design mode and type into the form, then click out of the form. I can't figure out why it's doing this.

+ 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. New to Forms-I would like to auto size a Frame
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-21-2013, 08:16 PM
  2. Auto Size and Hide on Forms
    By TraceyD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2010, 05:57 AM
  3. Auto size a pivot table to a page size
    By *.* in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2006, 12:09 AM
  4. [SOLVED] Auto Size Phot to Cell Size
    By Corey in forum Excel General
    Replies: 1
    Last Post: 05-30-2006, 04:55 AM
  5. Cell size? Or size limit for Text data type?
    By CClem in forum Excel General
    Replies: 0
    Last Post: 04-21-2006, 11:15 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