Automatically Print Sheet using Worksheet SelectionChange Macro

[eddieg]

I would like to enter the date in cell J2, hit enter, and have the sheet select J2 again, and print the sheet. I had this code once, lost it, and of course can't figure it out. thank you.

 

[My Aswer Is This]

If you enter today's date in the range("J2")
This script will run.
I had it give you a message box popup
Change this to the print code you want.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$J$2" And Target.Value = Date Then
MsgBox "Put you print code here"
End If
End Sub