Help with setting what I think Should be an easy macro

[sjoh527]

Hello All,

I'm trying to accomplish what I thought would be a fairly simple thing in terms of programming but it seems I've run into a bump. I'm attempting to create a Macro so that with the current active cell I can press my predefined hotkey\shortcut and it will do 3 things. Firstly will add text in the active cell that is hard coded like "Win At". Second it will move one column over then stamp the current date and time and that value will remain now static. 3rd it will now navigate left one column then down one row. My problem is using the =NOW() function it alters every previous cell that was set before. I assume that the issue is whenever a new cell uses the function =NOW() it updates every other cell that is using it. So the solution i'm looking for is how do I grab the current time but then set that cell's value so that it doesn't update when the NOW function is called again? I know that this is probably an easy fix but this is the first time attempting to use VBA in Excel or in general. Any insight will be greatly appreciated.

Cheers,
Sjoh527

 

[My Aswer Is This]

You said:

Second it will move one column over ​

Move over what way? Left or right?

 

[sjoh527]

You said:

Second it will move one column over ​

Move over what way? Left or right?

Ah second it will move one column right. Sorry i will edit that in the OP. Thanks

 

[mikerickson]

Try

With ActiveCell
    .Value = .Text & "Win At"
    .Offset(0,1) = Now
    .Offset(1,0).Select
End With

 

[sjoh527]

Try

With ActiveCell
    .Value = .Text & "Win At"
    .Offset(0,1) = Now
    .Offset(1,0).Select
End With

This worked XD. I knew it would be simple but just needed some extra help. Thank you very much.