Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Automatically Timestamp Entries in Excel in Multiple Sheets in same workbook

0

I viewed your video on how to do this and I used the code and created a macro and it works great on my worksheet. However i want the same to work on the multiple sheet in the same workbook. Please advice on this. For example i have 10 sheets(might add more) in a workbook in each sheet i have 10 colums and 11 and 12 is date entered and date modified.how do iĀ have date enteredĀ  and Date modified in column 11 and 12 in all the sheets.

Answer
Discuss

Answers

0

You need to add the same procedure behind every sheet on which you want a time stamp.

The code you have probably doesn't specify the sheet on which the stamp is to be visible. That means that it will be on the ActiveSheet which is the sheet behind which the code resides. You can specify another sheet for that, and you can specify the same sheet for all your event procedures. However, wahtever you do, you will need a separate event procedure to respond to the Change event on each of your worksheets.

For more help add your code to your question.

Discuss

Discussion

Please do let me know how to do that
MK25 Oct 17, '20 at 7:43 pm
Find the Edit button under your question. It's available only to you. Under the Edit screen there is a button "Add files to your post" (or words to that effect). You may have to scroll down a little to bring it into view. Click that button and follow the instructions.
Variatus (rep: 4889) Oct 17, '20 at 8:39 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login