Re: Private Sub Worksheet Change - Multiple on same worksheet
One more related question.
The date stamp appears in my table and outside my table.
First question
Is there any way to limit the date stamp inside the table?
See full code above...
Here is an extract of the code portion of the date stamp
For Each cell In Target
If cell.Value <> "" Then
Application.EnableEvents = False
Range("C" & cell.Row).Value = Now()
Application.EnableEvents = True
End If
Next cell
Display More
Second question
My table has data validation which limits the user input between 2 dates for some columns. I also have an input message telling the user how to enter the date when they click on the table column header. When I double click to change the column header title, I get an error with the following portion of the code :
The error is Run-Time Error 5 : Invalid Procedure Call or Argument.
I am still able to change the header title but this pop-up always bring me to the VBA debug or end options which is kind of annoying.
Any way to fix this?
Thanks!