+ Reply to Thread
Results 1 to 5 of 5

TextBox in userform wont jump to another row

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    TextBox in userform wont jump to another row

    Hi,

    I have inserted a Textbox inside of a userform in VBA:

    Skärmklipp.PNG

    The problem occuring here is that when you write something inside of that Textbox it only continues in 1 row, it doesn't appear on the next row.

    How can I make it so that it jumps to a new row whenever the first row is filled?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: TextBox in userform wont jump to another row

    Set it's MultiLine property to True.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    8,011

    Re: TextBox in userform wont jump to another row

    Select the textbox in the VB Editor and set the "Multiline" property to "True" in the Properties Window.

    If you cannot see the properties window, press F4.

    BSB

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

    Re: TextBox in userform wont jump to another row

    Try setting the "WrapWord" and "Multiline" in the TEXTBOX Properties to "True".

  5. #5
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: TextBox in userform wont jump to another row

    You guys are fantastic. I just learned something new. Thank you.

+ 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. Replies: 23
    Last Post: 07-12-2014, 07:09 PM
  2. Jump to record from textbox
    By ciprian in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2011, 03:37 AM
  3. Userform Textbox updating a another userform textbox (im stuck!!)
    By wapwap in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-31-2011, 02:56 PM
  4. Textbox wont read from hidden columns
    By ilovelagar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2009, 11:33 AM
  5. form textbox wont word wrap
    By Rob Hargreaves in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2005, 08:05 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