the people you can,
As long as ever you can.” - John Wesley
-
From: Brian
To: MS EXCEL AND VBA MACROS
Sent: Tue, September 13, 2011 11:38:50 AM
Subject: Re: $$Excel-Macros$$ Date from textbox reversed.
Thank you - both wor
Thank you - both work. and also thanks to Paul for helping me to
shorten my code
However, here is an interesting fact
If in textbox 1 I enter 12/9/11 the text in the worksheet shows a
9/12/2011 but if i enter
12/9/2011 then the text shows as 12/9/2011
On Sep 9, 7:52 pm, Paul Schreiner wrote:
> H
How is the date entered into the textbox?
perhaps Excel isn't recognizing the value as an actual "date"...
Try this:]
if (isdate(frmApplications.TextBox1.Value)) then
ActiveCell.Value = Format(frmApplications.TextBox1.Value)) , "dd/mm/")
end if
I'm suspecting that the value in the textb
Hi
Try
ActiveCell.Value = Format(FrmApplications.TextBox1.Value,"dd/mm/")
Thanks
Mahesh
On Fri, Sep 9, 2011 at 10:26 PM, Brian 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
>
