Dear Friends,
In the attachment I have 2 Name Ranges i.e. Project_A & Project_B.
When I am trying to Edit data on those Name Range, my created Userform to be popped up and demand for a data updation…
1. Requested by, Reason for Changes & Remarks I will enter it then, When I am press “Add to Database”
2. Requested by Content to be updated in C Column Last Blank Cell. Reason for Changes content to be updated in Column D Last Blank Cell. Remarks Content to be updated in Column E Last
Blank Cell Respectively
3. Whichever cell I am trying to Edit, in this Cas it is C7, The First column that is Column A and same Row content to be updated in Column B Last Blank Cell (In this case it is Product 6)
4. In Column A Last Blank cell, the current Date & Time to be updated.
After completion of “Changes Tracker” Worksheet updation, Now Excel should allow us to edit in the specified Name Range up to 60 Seconds from completion of “Changes Trakker” Updation or Saving of File (Which is First comes Up). After that for any further changes excel should demand a User form filling.
After User form popup, If I press cancel at any time, User form must close without any actions in changes tracker.
Thanks & Reagrds,
Rajeshkumar R
Bookmarks