Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    149
    Thanks
    67
    Thanked 0 Times in 0 Posts

    Smile Typing Data into a Textbox on a Userform

    Hi Experts,

    Entering data into a worksheet via a userform with textboxes is very useful. I have been doing this with success. However, when I hit the enter key to go to a new line in the text box a problem emerges. The cursor disappears from the textbox. I now use a shift-key to solve the problem.

    Is there a better way? Or is the shift-key the best solution?

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    excel,

    Make sure that for the textbox, multiline is set to true and EnterKeyBehavior is also set to true.

    HTH,
    Maud

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    Excelnewbie (2016-08-10)

  4. #3
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    149
    Thanks
    67
    Thanked 0 Times in 0 Posts
    Maud,

    You solved another problem. I'm very grateful you are here. Thanks!

    I looked high and low for a solution. Prof Google can learn a lot from you.

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    Lol....you are most welcome. Always glad to help you.

    Maud

Posting Permissions

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