$$Excel-Macros$$ Date in VBA

I am using a form to enter data and then from the textbox complete data in an excel spreadsheet. This is my code ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select ActiveCell.Value = FrmApplications.TextBox1.Value ActiveCell.Offset(0, 1).Select The first entry enters the date

Re: $$Excel-Macros$$ Date in VBA

Dear Brian, See attached sheet if it help.. On Fri, Sep 2, 2011 at 10:29 PM, Brian brianfosterbl...@gmail.com wrote: I am using a form to enter data and then from the textbox complete data in an excel spreadsheet. This is my code ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select