Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    162
    Thanks
    74
    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,754
    Thanks
    129
    Thanked 692 Times in 628 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
    162
    Thanks
    74
    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,754
    Thanks
    129
    Thanked 692 Times in 628 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
  •