How To Create An Excel Data Entry Form With a UserForm using VBA.Join this channel to get access to codes, perks, and see more interesting videos. Create the PHP file to read the form fields, make the connection to the database and insert the data … Begin by clicking 'Select Database', then 'New Source': Now select SQL Server and click Next. We can create SharePoint lists by using list templates, such as calendar and tasks, by importing spreadsheets, and by creating custom lists. From the Save As Type drop-down menu, choose Excel Macro-Enabled Workbook (*.xlsm). The workbook must be macro-enabled if you're using version 2007 or later. Notice the use of the