Thank you for this reply but it does not help. I obviously did not
explain this clearly
ActiveCell.Value = Date
ActiveCell.Offset(0, 1).Select
this code worrks fine as the date is automatically entered as dd/mm/
yyyy as I have set it in windows.
This is for the date when the data is being entered.
In Textbox1 I am enetering the date when a member joined and this is
the date that is being reversed to mm/dd/yyyy even though I enter it
as dd/mm/yyyy (my windows setting)
On Sep 2, 7:23 pm, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote:
> 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
> > ActiveCell.Value = FrmApplications.TextBox1.Value
> > ActiveCell.Offset(0, 1).Select
>
> > The first entry enters the date in column A correctly in the format
> > set for my computer dd/mm/yyyy
> > But in column B when the date is pulled in from the date entered in
> > textbox 1 it reverses the date to mm/dd/yyyy although my windows
> > setting has been set to what appears in colmn A
>
> > How do I correct this?
>
> > I am using Excel 2007
>
> > --
>
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> Book1.xlsm
> 24KViewDownload
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
