-
From: Brian brianfosterbl...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Fri, September 9, 2011 12:56:17 PM
Subject: $$Excel-Macros$$ Date from textbox reversed.
I am using a form to enter data and then from the textbox complete
-
From: Brian brianfosterbl...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Tue, September 13, 2011 11:38:50 AM
Subject: Re: $$Excel-Macros$$ Date from textbox reversed.
Thank you - both work. and also thanks
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
Activecell.Value = Date works
Hi
Try
ActiveCell.Value = Format(FrmApplications.TextBox1.Value,dd/mm/)
Thanks
Mahesh
On Fri, Sep 9, 2011 at 10:26 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
: Brian brianfosterbl...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Fri, September 9, 2011 12:56:17 PM
Subject: $$Excel-Macros$$ Date from textbox reversed.
I am using a form to enter data and then from the textbox complete
data in an excel spreadsheet. This is my