+ Reply to Thread
Results 1 to 2 of 2

How to make the field advance when user hits enter instead of saving incomplete on userfor

  1. #1
    Registered User
    Join Date
    12-27-2013
    Location
    Adeliade
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to make the field advance when user hits enter instead of saving incomplete on userfor

    Hi All,

    I have a userform that has combination of text and combo boxes, currently if I hit the enter button it saves what ever is on the form even if its incomplete. I would like the data only to be saved when I hit the command button that is assigned as "Add Record" I am very much a novice and would appreciate how this could be done.

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,168

    Re: How to make the field advance when user hits enter instead of saving incomplete on use

    Copy of workbook or code would be required to see why enter event is saving userform data in the first place

+ 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. Looking for a way to pause a Sub until the user hits the Enter key
    By mmcap64 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-27-2020, 10:28 AM
  2. To stay put in target cell when no value is entered & the user hits ENTER
    By MannStewart in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2020, 10:26 AM
  3. [SOLVED] Date separated by DOT to automatially convert into Slash as soon as user hits enter
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2018, 11:19 AM
  4. Format a row when user hits enter
    By jcmckeon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-29-2014, 01:42 PM
  5. How do I make one field auto-enter a value based on another field?
    By Hippiechld in forum Access Tables & Databases
    Replies: 7
    Last Post: 01-08-2013, 11:08 PM
  6. Detect if user hits cancel from user input type box
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2011, 11:42 AM
  7. [SOLVED] How do i require a user to enter a data in a field in Excel
    By Fred in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2006, 02:30 PM

Tags for this Thread

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