Re: [ExcelVBA] Userform Date

 

WOW imagine that it work !!!! LOL thanks

________________________________
From: David Grugeon <yahoo@grugeon.com.au>
To: ExcelVBA@yahoogroups.com
Sent: Friday, March 9, 2012 10:49 PM
Subject: RE: [ExcelVBA] Userform Date


 
i. I think Date is a function, not a variable so you may need to put parens
after it

Date()

The code could be reduced to one line

Cells(X,X).Value = Date()

Best Regards
David Grugeon
Excel VBA Group Moderator

-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of JIMNEELY
Sent: Saturday, 10 March 2012 5:25 AM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Userform Date

I have a big mental block going on. For some reason I can not figure out how
to add the date to a spreadsheet from a userform. What I mean is the user
puts all this stuff into the userform and then hits "OKAY" from there I want
to add this stuff to the spreadsheet plus the TODAY's DATE. I am thinking
the following

Dim MyDate
MyDate = Date
Cells(X,X).Value = Mydate

------------------------------------

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------Yahoo! Groups Links

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 9

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___