Question: I work on a program in VBA, there is an item number that beginning with MSK in column 3. Some of this MSK numbers are
I work on a program in VBA, there is an item number that beginning with MSK in column 3. Some of this MSK numbers are ended with letters K or V. User scan the Group number when clicking to start, after scan the Group number, Item number (MSK number) is loaded to Log page and in sheet 2 (Job page) column C4. I need to add code to this program when user scan the barcode, create a MSG BOX to user that shows MSK number is ended with letters K or V. The content of MSG BOX is: This serial number is ended with letter K or V, do you want to continue. Then user clik the Ok button to continue the process.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
