Would like to trigger a check mark in one column when date is entered in another

[Silverfoot]

Hi,
I have entered the following code in the worksheet in order to produce a check mark on clicking in the cell:

Please Login or Register  to view this content.

and it works really well. However, I would now like to trigger the check mark when a date is entered in column H. I have it formatted as "mm.dd.yyyy". Is there any way to do this? I am not really very familiar with Excel and would appreciate any assistance possible. Hope I've done this right as it's my first post.
Thanks

[Palmetto]

code revised to test for valid date in column-H cells

Please Login or Register  to view this content.

[Silverfoot]

Thanks for the input, but unfortunately it doesn't work. I have removed the old code and pasted yours as above, but the font in Column H is in Marlett when entering the date and there is no resultant check mark in Column G. Am I doing something wrong?

[Palmetto]

I had forgotten to change the range string.
If you want cells in column-G to get a check mark when a date is entered in column-H cells then the target range must be H3:H50.

If the date is valid, then we offset one column to the left of the target and enter a checkmark.
Is this what you intended?

Code in prior post is revised and works per above.

[Silverfoot]

Thank you Palmetto! It works brilliantly, I was tearing my hair out...I am so grateful.
Out of interest, can a custom date format be specified? I use mm.dd.yyyy rather than mm/dd/yyyy. It's no big deal but it would be interesting to know.
Again, many thanks, really appreciate it.

[Palmetto]

Since you are working with a fixed range I would just format the date cells (column-H) using the normal Cell Format dialog.

However, if you want to do this via code, then:

Please Login or Register  to view this content.

I think it is best, though, to use the default format.

[Silverfoot]

Thank you so much for all your help. I did format the H Column using the Cell Format dialog, but it doesn't work, so I will try the code. I really appreciate you taking the time to solve my problem, great forum.