267,955 views
Step-by-step instructions for creating a comprehensive data entry form (customer management) that stores the created data records in a database. Data records can be created, edited and deleted. Free VBA introductory course: https://vbatrainer.mykajabi.com/offer... VBA coaching: https://www.vbatrainer.de/ Template for the video: https://vbatrainer.de/eingabeformular... To the blog post: https://vbatrainer.de/eingabeformular... ________ LINKS to other Excel VBA videos ► Warehouse management: • Warehouse management application in Excel V... ► Hide Excel interface: https://vbatrainer.de/excel-interface... ________ Timestamps 00:00 Aim of the video 00:49 Design heading 6:22 Design database 13:01 Design input mask 21:33 Create data record 29:08 Edit data record 36:14 Save created data record 44:16 Save edited data record 51:28 Delete data record 54:50 Lock and unlock relevant cells 1:00:51 Hide Excel interface 1:03:16 Execute code on opening