Re: $$Excel-Macros$$ Date from textbox reversed.

2011-09-13 Thread Brian
- 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

Re: $$Excel-Macros$$ Date from textbox reversed.

2011-09-13 Thread Paul Schreiner
- 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

$$Excel-Macros$$ Date from textbox reversed.

2011-09-09 Thread Brian
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

Re: $$Excel-Macros$$ Date from textbox reversed.

2011-09-09 Thread Mahesh parab
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

Re: $$Excel-Macros$$ Date from textbox reversed.

2011-09-09 Thread Paul Schreiner
: 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