Hi,
I'm totally new in Excel and VBA, so excuse me with my request to provide to me "as is ready" code.
What I have - an excel sheet with SNs in column e.g. A1 ~ A500, and names in column B1 ~ B500
What I want to achieve -
a) if scanned SN match some SN of range A1~A500 mark it as green + set date/time in corresponding cell in C row (arrive)
b) if scanned SN match some SN of range A1~A500 at 2nd time mark it as red + set date/time in corresponding cell in D row (leave)
To achieve it, we can setup some trigger somewhere in this or other sheet, e.g. in corresponding cell E put 1 after 1st match, 2 after 2nd.
c) is there possibility to prepare some worksheet with some input's filed/sheet etc? Cause I believe the variable (scanned SN) must be in
some cell e.g. X1, right? I don't want to see the X1, X2, etc scanned SNs, but rather some "GUI" which will do next:
- after 1st scan, if SN match will popup that "name from corresponding cell B" arrived message
- leave empty filed and wait/sleep 2 seconds before next scan
- after 2nd scan SN match will popup that "name from corresponding cell B" left message
- if SN do not match popup "please try scan again, or so" message
- if 3rd scan, maybe again arrived + set date/time to another cell?
- if 4th scan, maybe again leaved + set date/time to another cell?
Many thanks in advance for help.
Regards
jyndros
Bookmarks