+ Reply to Thread
Results 1 to 4 of 4

Highlight correspondinng number from scanned QR code

  1. #1
    Registered User
    Join Date
    02-09-2021
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    2

    Highlight correspondinng number from scanned QR code

    Probably a simple question that has already been asked. When I scan a qr code (usb or mobile phone) excel should highlighted the corresponding cell (customer number)
    Last edited by AliGW; 02-09-2021 at 09:14 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,586

    Re: Highlight correspondinng number from scanned QR code

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new, I have done it for you today.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,586

    Re: Highlight correspondinng number from scanned QR code

    Probably a simple question that has already been asked.
    Probably. Did you search the forum?

    It has been asked, yes, but I'm not clear what the envisaged workflow is: how would it be scanned and how would that data then be entered into the workbook? Or are you anticipating something else?

  4. #4
    Registered User
    Join Date
    02-09-2021
    Location
    Belgium
    MS-Off Ver
    365
    Posts
    2

    Re: Highlight correspondinng number from scanned QR code

    My apologies but this was my first post on the forum. I actually wanted to ask: I have an auction house and after an auction, customers have to pay within 7 days. These payments are kept in an Excel list. The first column of this list is their buyers number. If a customer shows a confirmation email (printed or on their phones) with a QR code (QR code = customer number) when they come to collect their goods, I want to scan this QR which should highlight the customer number in the Excel payment list, so that we can immediately can see if that person has paid. In concrete terms, after a scan (possibly via a filter system) 1 cell should display the buyer number on the paylist in the first column. So the scan not adds info to the sheet but only track info.

+ 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] Code to display text & code in a combo list, but display only code when selected
    By kdestef1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2019, 06:07 PM
  2. [SOLVED] Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.
    By FragaGeddon in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-30-2015, 11:46 AM
  3. [SOLVED] Pattern Building VBA Code - Working code, would like to use cleaner code
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2015, 03:05 PM
  4. [SOLVED] Excel VB code. Message pops up while code running asking question. Code must not wait.
    By Heinrich Venter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2014, 06:10 AM
  5. [SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table
    By cteaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2014, 08:01 PM
  6. Replies: 2
    Last Post: 03-09-2013, 04: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