Time and Date Macro

**dlh116** · 10-28-2009, 02:56 PM

Write a macro to put the current date and time in cell A1 on Sheet1. It should display the current date and time to the second. The time only has to change when you run the macro. Create a hotspot to run the macro.

**Leith Ross** · 10-28-2009, 03:22 PM

Hello dlh116,

Welcome to the Forum!

What do you mean by a "hot spot"?

**dlh116** · 10-28-2009, 03:34 PM

I am not exactly sure. Those were the instruction I was given by my professor. I'm guessing it is supposed to be hot key.

**royUK** · 10-28-2009, 03:40 PM

This is a college question?

I believe a "hotspot" is more often used on web pages.

Is your professor teaching Excel?

Here's an example - click timer to update, as it appears to be homework you cn figure out how it's done

**yunesm** · 10-28-2009, 04:10 PM

This would work for the macro. I assume he wants it assigned to a button (see attached worksheet).

Please Login or Register  to view this content.

Hope this works out...
Later

**royUK** · 10-28-2009, 04:16 PM

YUNESM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You do not need to select cells in VBA. Your code adds the NOW formula to the cell, this will change whenever the sheet is updated