Lookup a date in a column and finding specific text value row and clear

[kx1bn7]

I have search everywhere for a solution. I have a userform where the user will identify a record to delete. I need to search another worksheet (Month) for the event's name which is associated a date. Once it finds this event's name I need to clear the contents of that cell.

Here is the code I am using for the record deletion from the 'Data" worksheet. I need to also locate and clear the cell as stated above.

This is the last part of a large program and any assistance is much appreciated.

Please Login or Register  to view this content.

[kx1bn7]

All,

Help on this would be much appreciated.

KX1BN7