Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
Can a Data Form field be automatically populated with current date? Tying to
avoid having users type in this field for every row entered. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
Steve,
Copy the code below, right click the sheet tab, select "View Code" and paste the code into the window that appears. This code will put the date into column A of any row where data is entered IF that cell is currently blank. HTH, Bernie MS Excel MVP Private Sub Worksheet_Change(ByVal Target As Range) If Cells(Target.Row, 1).Value < "" Then Exit Sub Application.EnableEvents = False Cells(Target.Row, 1).Value = Date Application.EnableEvents = True End Sub "Steve" wrote in message ... Can a Data Form field be automatically populated with current date? Tying to avoid having users type in this field for every row entered. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form
I appreciate the response very much Bernie. However this would appear to work
for a worksheet. I am attempting to get the date into a dataform that is to be populated and can't enter a formula directly into the form. The worksheet is only populated when Enter is pressed but the date would have already been entered into the dataform. "Bernie Deitrick" wrote: Steve, Copy the code below, right click the sheet tab, select "View Code" and paste the code into the window that appears. This code will put the date into column A of any row where data is entered IF that cell is currently blank. HTH, Bernie MS Excel MVP Private Sub Worksheet_Change(ByVal Target As Range) If Cells(Target.Row, 1).Value < "" Then Exit Sub Application.EnableEvents = False Cells(Target.Row, 1).Value = Date Application.EnableEvents = True End Sub "Steve" wrote in message ... Can a Data Form field be automatically populated with current date? Tying to avoid having users type in this field for every row entered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
Data Form | Excel Discussion (Misc queries) | |||
format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
have 3 worksheets, 1 is a form, the other 2 data for the form-wan. | Excel Worksheet Functions |