hendyhellen
New Member
- Joined
- Jul 29, 2023
- Messages
- 19
- Office Version
- 2019
- Platform
- Windows
- MacOS
Hello again all~
Since i need to complete the simple code for my warehouse, i got stuck for this function and would like to ask the code for this issue :
I need to validate TextBox1 must be filled => if EMPTY show dialog box 'CAN'T EMPTY' and focus on textbox again
then IF QR Code not found on the Sheet Data => show dialog box 'NO BARCODE FOUND' and focus on textbox again
IF QR CODE found => the Print_Label will work and focus on textbox again for the next input
Here is the file : Scanning-LABEL
Any help is very appreciate it
Thank you so much
Since i need to complete the simple code for my warehouse, i got stuck for this function and would like to ask the code for this issue :
I need to validate TextBox1 must be filled => if EMPTY show dialog box 'CAN'T EMPTY' and focus on textbox again
then IF QR Code not found on the Sheet Data => show dialog box 'NO BARCODE FOUND' and focus on textbox again
IF QR CODE found => the Print_Label will work and focus on textbox again for the next input
Here is the file : Scanning-LABEL
Any help is very appreciate it
Thank you so much