I have a Data Entry Form that captures data entered to a table in a different sheet in the same workbook.
I want to include the Date the data is entered in a new column in the data table. I want the date been enter with out the user entering or typing the date. After the user makes a data entry with the OK button, I want the code to capture the date and input it with the rest of the info enter in the same row.How can I format a label that will display the date (today’s date) in the Input form and make the "OK" buttom code capture this value (data entry date/today’s date) to the data table? Lets name the sheet were the macro initializing the entry form ” Entry Form Sheet” and where the data table is name “Raw Data Sheet”. I’m following the format use in this example form;