Gary H
New Member
Hello all.
Apologies if this question may have been answered before but I've tried the usual searches including Search Engines etc. and either can't seen to find anything, or my lacking in skills stops me from interpreting the answers. Also apologies in advance for the long post...
Okay, so my current project is to make our current silo records (I work for a Coffee Company) digital so that the data can be extracted from a spreadsheet. I've created a User Form for the bean store operators to complete when they load the coffee into the silos. I have it cobbled together from various search results/posts from forums etc. (the code and layout is probably not very pretty or efficient) and it works. However, I would like to make it more secure when entering some of the data.
The first combo box is the stock code for the raw coffee and the second text box is the warrant number for that particular crop - these are both to be entered via a barcode scanner, so I would like to make it whereby they can only be scanned into their relevant fields. I figure this would require some sort of check and error message if it was incorrect, preventing the operator from continuing unless the correct barcode is scanned.
I am also struggling to make it whereby the form clears itself once submitted and cannot be submitted unless all fields are filled (avoiding blank rows on the spreadsheet).
This is my first venture into VBA so please don't be afraid of treating me like a complete newbie - I almost certainly will need to ask questions later...all help is greatly appreciated in advance.
Gary
Apologies if this question may have been answered before but I've tried the usual searches including Search Engines etc. and either can't seen to find anything, or my lacking in skills stops me from interpreting the answers. Also apologies in advance for the long post...
Okay, so my current project is to make our current silo records (I work for a Coffee Company) digital so that the data can be extracted from a spreadsheet. I've created a User Form for the bean store operators to complete when they load the coffee into the silos. I have it cobbled together from various search results/posts from forums etc. (the code and layout is probably not very pretty or efficient) and it works. However, I would like to make it more secure when entering some of the data.
The first combo box is the stock code for the raw coffee and the second text box is the warrant number for that particular crop - these are both to be entered via a barcode scanner, so I would like to make it whereby they can only be scanned into their relevant fields. I figure this would require some sort of check and error message if it was incorrect, preventing the operator from continuing unless the correct barcode is scanned.
I am also struggling to make it whereby the form clears itself once submitted and cannot be submitted unless all fields are filled (avoiding blank rows on the spreadsheet).
This is my first venture into VBA so please don't be afraid of treating me like a complete newbie - I almost certainly will need to ask questions later...all help is greatly appreciated in advance.
Gary
