+ Reply to Thread
Results 1 to 2 of 2

Help !Enter ID>>auto search for blank cell>>prevent closing of excel>>re-enter ID to close

  1. #1
    Registered User
    Join Date
    03-25-2016
    Location
    singapore
    MS-Off Ver
    2010/2013
    Posts
    15

    Help !Enter ID>>auto search for blank cell>>prevent closing of excel>>re-enter ID to close

    The ideas is to prompt out a input box that ask the user to key in ID, number only value. then it will auto search for a first blank cell founded in column H to allow the barcode enter from there. while the user is key in the barcode away from the PC using Bluetooth barcode scanner, the excel must not close by others user. to close it, user must enter the same ID The code only work until the enter value is true then it wont select the cell
    Last edited by jiaweilee; 03-25-2016 at 02:51 AM.

  2. #2
    Registered User
    Join Date
    03-25-2016
    Location
    singapore
    MS-Off Ver
    2010/2013
    Posts
    15

    Re: Enter ID>>auto search for blank cell>>prevent closing of excel>>re-enter ID to close

    Please Login or Register  to view this content.

+ 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: 1
    Last Post: 03-25-2016, 01:16 AM
  2. [SOLVED] Enter number in blank cell match number on sheet 2 & enter data from adjacent cell
    By Bikeman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2015, 08:36 PM
  3. [SOLVED] Prevent user from closing worksheet if cell is blank
    By maryren in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2013, 12:11 PM
  4. Replies: 2
    Last Post: 07-19-2013, 10:13 AM
  5. search and enter specific information on the next blank line without deleting
    By jlo33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-15-2013, 10:03 AM
  6. Auto enter data from cell above on enter
    By GSXR1000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2006, 10:06 AM
  7. [SOLVED] Enter name on 1st worksheet and have it auto. enter on all others
    By pattyh in forum Excel General
    Replies: 4
    Last Post: 03-08-2006, 08: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