+ Reply to Thread
Results 1 to 2 of 2

textbox to cell: fixed width

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    22

    textbox to cell: fixed width

    Hello,

    In my userform I copy multiple textboxes to multiple cells on the same row in a sheet(i.e. textbox1 to a1, textbox2 to a3, textbox3 to a5). If the text in the cell is to long the text in a1 will overlap the text in a3 (or be truncated). Is it possible that the width of my cells will be fixed? I mean that instead of expanding in the width, the cell will expand in height(i.e. start a new row in the cell)?

    Mabulco

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: textbox to cell: fixed width

    Just set your cells to wrap text enabled?

+ 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. keeping the cell width fixed while concatinating
    By abhimaan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2012, 03:35 PM
  2. Fixed Width Text to Excel with fixed break lines.
    By jameel30 in forum Word Formatting & General
    Replies: 1
    Last Post: 08-10-2012, 08:57 PM
  3. Replies: 0
    Last Post: 03-29-2012, 01:05 PM
  4. Parse text in cell, on fixed width
    By HMM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2010, 04:25 PM
  5. UserForm TextBox with fixed Width and dynamic Height
    By Soniya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2006, 04:45 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