Visual basic code for auto generation of time

Asked By rosellas phillips 10 points N/A Posted on - 08/07/2013

Hello Techyv Friends,

I am in need of visual basic code for auto generation of time and date based on the updating of a cell in Excel. 

Please do the needful for providing the same. 

Example: If I update the cell A1, the date and time of updating needed to be automatically updated into cell B1.

• Status: Open
• Question Views: 782
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Wiley Kolar 15 points N/A #165299

Visual basic code for auto generation of time

The most straight and simple solution for this is to attach a few lines of VBA code to the worksheet you want this functionality to.

To add date and time automatically added to cell 'B1:100' for changes in 'A1:100':

• Right click on the sheet tab, you want to do this
• Select 'View source' option
• Write a macro. You can either use the code from Add date/time to cell upon entry automatically, which explains add date time automatically, or write some custom code based on it

About Wiley Kolar

Questions
1

Answers
101

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 11/17/2013
• Question Category: Visual basic