+ Reply to Thread
Results 1 to 3 of 3

Userform input box selection

  1. #1
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Userform input box selection

    Hello,

    I have a userform which has multiple TextBoxs.
    I am using the following code to check the input for numerical values:
    Please Login or Register  to view this content.
    I am using the .SetFocus to try to keep the mouse selecting TextBox4 (to bouncing back into TextBox4) after the user trying to move to another input
    The .SetFocus, won't do the work, I am able to navigate away into another box which I want to avoid.

    Does anybody know how to achieve this?
    Thanks

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

    Re: Userform input box selection

    Set Cancel to True.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Re: Userform input box selection

    Norie,
    It works, thank you so much!

+ 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. Copy Data from Database to Input Sheets Using Userform Selection
    By Rudidw in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-26-2020, 11:59 AM
  2. Get Multi Selection Listbox userform and clear all selection
    By jp16 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2018, 10:43 AM
  3. [SOLVED] Userform ComboBox selection not displaying on first attempted selection
    By yachrishere in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-01-2016, 07:44 PM
  4. UserForm ComboBox selection to activate WorkSheet selection row.
    By excelV3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2015, 12:35 PM
  5. Replies: 1
    Last Post: 06-03-2013, 06:30 AM
  6. Using a UserForm to call different sheets and input the data upon a selection.
    By seansimi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2013, 10:07 PM
  7. Replies: 4
    Last Post: 11-28-2012, 06:09 PM

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