DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Making Excel record a the time

Thread Solved

•

Join Date: Sep 2005

Posts: 16

Reputation: grandfilth is an unknown quantity at this point

Solved Threads: 0

grandfilth grandfilth is offline

Offline

Newbie Poster

Making Excel record a the time

Oct 29th, 2005

I'd like excel to write the time when one of my macros tells it to copy and paste some cells into another workbook. I'd like it to paste the time into the other workbook. Any help would be much appreciated.

•

Join Date: Oct 2005

Posts: 21

Reputation: SlyMaelstrom is an unknown quantity at this point

Solved Threads: 2

SlyMaelstrom SlyMaelstrom is offline

Offline

Newbie Poster

Re: Making Excel record a the time

Oct 29th, 2005

http://msdn.microsoft.com/library/de...lywhenisit.asp

Try this.

If you're not up for reading it, the code would be:

Sub CopyWorksheet_Click()

Range("A1").FormulaR1C1 = Now

End Sub

•

Join Date: Sep 2005

Posts: 16

Reputation: grandfilth is an unknown quantity at this point

Solved Threads: 0

grandfilth grandfilth is offline

Offline

Newbie Poster

Re: Making Excel record a the time

Oct 29th, 2005

•

Originally Posted by SlyMaelstrom

http://msdn.microsoft.com/library/de...lywhenisit.asp

Try this.

If you're not up for reading it, the code would be:

Sub CopyWorksheet_Click()

Range("A1").FormulaR1C1 = Now

End Sub

How do you make this work though? Sorry I'm a bit thick! How would I put this into a function so that a cell would read the time?