This UserForm allows to read data from barcode scanner. If barcode is new, user fills in the fields and clicks on "Save" button to add it to database. In case barcode already exists in database, form fills in automatically. User can edit data and overwrite. Edits can also be done by manually entering or pasting barcode and then changing & saving data. Such forms can be very convenient, visually appealing and provide a high level of data validation through macros. It must be considered however, that doing the same functionality in Excel cells is faster to create, easier to adjust and with proper formatting, for example hiding gridlines and column / row headers, simple worksheet can be a good, professionally looking tool for data entry (with database in different worksheet).