Storing date and time

N

Noepie

Hello,

I have several macro's which are run periodically. I'd like to store the
date and time in the cells next to each of the macro buttons after the macro
was executed. Does anyone know how to do this with VBA-code?

Thanx.

Noepie
 
M

Mike H

Maybe this

Sub Button2_Click()
Range(ActiveSheet.Buttons(Application.Caller).BottomRightCell.Offset(-2,
1).Address).Value = Now
End Sub

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Macro Not Executing - Need Help 1
Renaming Worksheet 3
I figured out the issue thank you. 0
Simple Variable to someone 5
VBA Coding Help for Beginner 0
Multicopy worksheet 5
Clearing Fields in a Word Form 5
Getting Radio Buttons to work, that are inserted via AutoText 0

Top