Date macro's in Excel

January 10, 2012 at 06:00:24
Specs: Windows 7
Attempting to have a current date enter into a cell automatically when cell has been highlighted? Any suggestions or answers on how to do so??

See More: Date macros in Excel

Report •

#1
January 10, 2012 at 07:45:47
When you say "highlighted", do you mean selected?

If you mean selected, are you working with a specific cell or perhaps a range of cells? I can't imagine that you want this to occur throughout the entire worksheet.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 11, 2012 at 12:13:57
Thanks for taking interest.
Yes I meant selected and to be honest I am not sure that I need a Marcro to do this I was told this by someone else.
Anyhow it is Office 2010 and I am attempting as mentioned to select a cell and a current date/time automatically enter cell. Is this possible??? and no not the entire worksheeet just different multiple cells.

Thank you


Report •

#3
January 11, 2012 at 17:01:43
Yes, you need a macro if you want the current date to end up in a cell upon selection.

However, since macros need very specific instructions written to have them do exactly what you want them to do, we would need something more specific than "just different multiple cells". Which cells?

In addition, you asked for the current date in your first post, but for the current date/time in your second post.

Which is it?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
January 12, 2012 at 03:52:09
OK sorry for my ignorance in ansking the questions that I have. Hopefully I will be a little more detailed with this.
1. Need several different cells on one sheet to display a current date and or date/ time stamp automatically when cell or cells are selected
2. Now that I know I need a macro to accomplich this how would I write the macro or whatever I need to do to make this happen
3. As for which exact cells I currrently do not know which exact cells I am wanting to do this with. I am assuming that when the macro is written the cell/s I am attempting to do this too are entered at that point???
Thanks again

Report •

Ask Question