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;
Using the example you cited, I made changes to include the date. Replace your OK button code with the code here. It will place the date in column "E" of the row the data was entered in. The date format is Sep-01-2007. The code is highlighted in blue. This code could be improved, but I didn't want to confuse you with too many changes that may make it hard to follow.
Ross, thanks for you replay. I understand you code to a certain point. But it won’t work the way I wanted
Let’s make it more simple; If I will have a simple from with just a label how can I programmed it to show today’s date, how can I capture that date and with a OK command button save it to a particular cell in the same workbook but in a different sheet?
Here is a code example of an "OK" button to place today's date in cell A1 of Sheet2. If this isn't what you want, post the code you do have. Don't redirect people to a URL whose code example doesn't match the code the you using.
Bookmarks