UserForm automation

par Taisho
Portfolio

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).

image of username Taisho Flag of Poland Góra, Poland

Me concernant

My main areas of expertise are VBA macros (Excel, web scraping) and WordPress speed optimization, where I regularly achieve 95+ score in Google PageSpeed Insights / GTmetrix. I also develop WordPress plugins, mostly WooCommerce-related. In Excel VBA I like to work on big data sets, for example, stock market and Forex data, where code performance matters. I'm proficient in standard Excel tools: formulas, charts, graphs, pivot tables, conditional formatting, Solver, etc. VBA: - over 8 years of experience - Excel automation - web scraping - passing data between Excel, Word, text files, etc. - rearranging data structure - sending e-mails based on Excel data - operations on files and folders - UserForms - custom formulas - macro speed optimization WordPress (PHP, jQuery, JavaScript, HTML, CSS) - over 3 years of experience - website speed optimization (Google PageSpeed Insights, GTmetrix) - fixing websites, small customizations - plugin development, mostly for WooCommerce

$15 $ US / h

69 évaluations
5.4

Étiquettes