Ok, here it is i am copy pasting a code and again providing a link to the file and the video that i have made.
Below is the code that ThisWorkbook contains
the above code basically, to my understanding, checks the system time for me and then if it matches it initiates the code,mind you the TimeValue is in 24hr format
the below code is the MODUE 1 that i need to insert
This is where it will process the code and i have reffered it to a sub in the actual worksheet where the action should be done
Below is the code in sheet2
my question once again is that, this is a live as you have seen it in the video , how to make these values freeze or stop once its 8'oclock
Bookmarks