Grettings people
just need someone to help me with completing my macros code. I am trying to get a cell to display a code when i enter a number into another cell. I have most of the code but i am looking to add in another line that enables me to delete all data in the output cell when the input cell is blank.
here is what i have so far
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect([D7,Target) Is Nothing Then
Application.EnableEvents = False
Cells(Target.Row, 2) = Now
Application.EnableEvents = True
End If
End Sub
As i mentioned earlier, once the input cell is blank it should erase all data in the output cel.
Sorry guys, I know this seems easy but i am having a really bad mental block today.
appreciate the help
cheers
Bookmarks