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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!