I am tryingto build a workbook which will allow me to validate a Grain Harvest Management Scheme (GHMS) number provided by a truck driver. The origonal data will be obtained from another source and maintained within this workbook by an administrator.
The user (weighbridge clerk) will only have access to the form, and should be able to simply enter in a GHMS number or a truck rego and have the correct data filled in the other fields. There will be a maximum possible 9999 rows of data on one sheet only, and its unlikely this will be filled within the next 10 years. I expect that the worksheet will only contain around 3000 rows of data at this stage.
Whilst the initial form design has a combobox to scroll select the GHMS number I will change it to allow the user to type in a number or rego to retrieve the correct data.
I also intend to build a toggle button hidden in an image so that the Administrator can turn on or off the worksheet visibility, but this is a down the track process. Could someone check over the code provided and tell me where it may be improved.
Thank you