+ Reply to Thread
Results 1 to 2 of 2

VBA Userform TextBox1_Change() triggering.

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Lithuania
    MS-Off Ver
    Office 2013
    Posts
    52

    VBA Userform TextBox1_Change() triggering.

    Hello,
    I have a macro which uses entered value from TextBox1. If a value is given to TextBox1 as a whole, the code runs fine. If a value is entered character by character (scanned with a handheld barcode scanner) the code: TextBox1_Change() triggers on every character.
    How to make the macro start only when the whole value is entered (the length of the value may differ)? Maybe there is a way to catch the barcode scanners ENTER?
    Extra buttons to manually trigger the code are not an option.

    Thank you for your time and help.

    P.S. also asked here https://stackoverflow.com/questions/...nge-triggering
    Last edited by baxius; 02-10-2021 at 11:43 AM.

  2. #2
    Registered User
    Join Date
    11-07-2019
    Location
    Lithuania
    MS-Off Ver
    Office 2013
    Posts
    52

    Re: VBA Userform TextBox1_Change() triggering.

    Solved with this:
    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. [SOLVED] TextBox_BeforeUpdate, TextBox_Change
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-30-2019, 08:55 PM
  2. [SOLVED] Advice on Non Active Userform triggering event
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2019, 10:01 AM
  3. [SOLVED] Worksheet needs certain cells to have a value before triggering the userform.
    By danbates in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-03-2017, 05:17 PM
  4. [SOLVED] textbox_change : no find do nothing
    By mabulco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-12-2013, 07:37 AM
  5. Triggering UserForm from Keyboard Shortcut
    By BeefNoodleSoup in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2012, 03:11 AM
  6. Cell Value Change triggering UserForm
    By danygiguere23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2012, 10:38 PM
  7. Userform combo box triggering macros
    By michaelberrier in forum Excel General
    Replies: 6
    Last Post: 06-10-2006, 08:30 AM

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