Using a hyperlink to place Todays Date in an adjacent cell

[Nick Mill]

Hello,
I am trying to make a series of checklists for fall/spring or other activities that would allow someone to click a hyper-link ( name of link will read "Done") and see Todays Date in the adjoing cell to the right, ( to indicate the date chore was accomplished). I have only very basic knowledge of Excel ( learning basic formulas and functions). I plan to learn more but do not have any knowledge of scripting or macros yet... I just can't figure it out yet..
I am working on 2 systems, both XP... one with Excel 2002, the other with Linux Open Office.
Any help you can give would be greatly appreciated...
Sincerly,
Nick Mill

 

[wigi]

Hello

If you fire the shortcut command Ctrl-; today's date will be put in the cell you are selecting. This requires no coding at all and will be easiest.

 

[Nick Mill]

Wigi,
Thank you so much ! It does help me, and perhaps I should have mentioned ( I appologize ) that this is a commercial type form. It is to make life easier for people. There is a "fall checklist" for people doing fall chores. When they are done they simply click the link "Done" and I'm hoping I can get that date in the adjoing, or even same cell.
I am very gratefull for any help any one can give.
Sincerely,
Nick Mill

 

[Nick Mill]

Wigi, Thank you so much ! It does help me, and perhaps I should have mentioned ( I appologize for that) that this is a commercial type form. It is to make life easier for people. There is a "fall checklist" for people doing fall chores. When they are done they simply click the link "Done" and I'm hoping I can get that date in the adjoing, or even same cell.
I am very gratefull for any help you or anyone else can give.
Sincerely ,

 

[wigi]

If you work with a command button (or similar), you could have code like this to put the time in the cell to the right of the active cell:

Sub Done_Time()

    Selection.Cells(1).Offset(, 1).Value = Now

End Sub

This code goes in a normal module.

If you would want to execute code when the user clicks any hyperlink, you can use this event:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

    Done_Time
    
End Sub

This code should be put in the sheet's code module: right-click the tab at the bottom of the screen, show the VBA code, and paste this code. Close the VBA programming environment. Instead of executing the code contained in the macro Done_Time, you can have other code if you want.

 

[Nick Mill]

Wigi,
Thank you so much for your time and effort...
I will work on this.. and I just started a Macro Tutor program from Microsoft.
Thank you again !
Nick