Insert current date (static) when cell is clicked?

Ok. Got that into the module. Now how do I apply it to certain cells in the worksheet? Sorry, I have no experience with working with these custom functions.

No problem, we are here to help you learn.

What Cell(s) do you want to apply the rule to?
Is it only on one sheet in the workbook?

Just finished a meeting and this project is no longer needed. Thanks so much for taking the time to help me with this anyway guys!

Okay , but for future reference

Please Login or Register  to view this content.

This would then only work for Cell A2
Sheet protection might also come into play, but that can be addressed later if ever required.

Cheers

Thank you so much! I learned something today!

Thanks a lot for this code. Actually i was searching the same on excelforum and i found it. But my issue is little bit different. Actually, I want to continue this macro from H2 to H(maximum). Please tell us a code in which we can use this code from H2 to H(maximum).

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "A2" Then
If Target.Value = "" Then Target.Value = Date
End If
End Sub

Originally Posted by Marcol

Hi bodmas

Read the forum rules before the moderators get you...

Forum Rules
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

If you can Edit/Delete your post, do so, if not you'll need to ask a moderator to help you.

Cheers

@Marcol ~ My concern is almost same as asked in the thread "Insert current date (static) when cell is clicked?". Still! i need to start a new thread and ask the same query.

Hi there,

Could you tell me how this code can be modified to only work for the cell range C:4:K40?

Thanks

Its an old thread, I have forfeit this project.