Excel VBA Format Cells and Track Changes

Hello everyone,
Sample.xlsm
I have a VBA code that track and log changes whenever a cell value (price, implementation date, description) is revised in all the worksheets. I got this from internet and tweak a little to customize according to my needs.

There are still things I wanted to do but I don't know if possible and how to code it.
1. Limit tracking changes to sheets "Project Data" and "Project Part Data" -- it won't track changes from all other sheets.

2. Format cell value (old value and new value) logged in the tracker such that it has the same format with the worksheet it originated from (price should be number, implementation date should obvioulsy be date, description can either be general or text).

I've attached a sample workbook.

Hoping you could help.
Thanks.

Originally Posted by protonLeah

1.

Please Login or Register  to view this content.

That's quick! Thanks prontonLeah!
I have an additional question though.. In project data and project part data sheets, there are columns that I would not like to track the changes. How will it be done?