Hello all, Here's what I am trying to accomplish...
I've create a macro to place the current time in a cell...say A1...and I've created a command button to do this...so every time I click the command button the updated time will be displayed in A1 and only A1. What I want to be able to do is that everytime I click on the command button to update the time in A1 it copies that information to another cell...say B1...and once B1 has been filled with the same time that was just updated in A1 the next time I go to update the time in A1 then that time is entered into cell B2...and then next update entered in A1 also appears in B3, etc. Essentially, this creates a list of all the times that were displayed in A1. Thank you very much in advance for any advice on how to accomplish this!! --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
