Results 1 to 3 of 3

Thread: Help Required in Create and Open Folder and Track Changes

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Mentor
    Joined
    Nov 2020
    Location
    Cochin, Kerala
    Posts
    314
    Location

    Help Required in Create and Open Folder and Track Changes

    Hope you all are good and safe
    Could somebody please help in modifying the codes as required below-

    In the attached workbook there are two set of codes-

    Sheet ("Follow-up Tracker")
    Code checks the duplicates in column A and add a value in column V 'Follow-up Audit Files' against the row
    And on selection change with Column V, it notifies the missing columns and creates / Open folder in the workbook path
    / Follow-up Audit Files/ Value in Column B / Value in Column A

    I need help in changing the trigger from selection change to enter or double click in column V as now moving around the worksheet notifies and creates / open the folders

    Sheet ("Track Changes")
    I need to track only the changes in sheet "Follow-up Tracker' and not the changes in all the sheets and that too as per the example format given in sheet Track Changes 2
    Cell Changed shall be Unique Code for the row and Column Heading for the column changed

    Thanks in advance for your help!
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •