Call in the Cavalry - 2019

Migrate Excel UserForm to Access Database Form

This is a Commercial Services thread.

This user has an Excel file with a UserForm that does several updates to worksheets. OP wanted this ported to Access so that the code would still update the Excel file. I imported the UserForm and rewrote the code so that Access could execute the code to update the Excel file. I used late binding. However, the user did not want it just ported as a VBA UserForm, user wants a new Access form created to emulate the same functionality. I do not know how to link actions on an Access form to VBA and it's not worth the time it would take me to learn it just for this one question. OP has valued thread at 50 points.

The Access data is almost 20MB so cannot be attached to the thread. I received the file and send a solution via email with the OP.