Quote:
Originally Posted by Seeker2025
Good day to everyone!
I am looking for a VBA code that will apply to certain cells based on their value.
I want to create a job pickup time tracker for three shifts in each sheet each day, each with different operators, and upon the duration of the job and the region that many cells to be highlighted.
Example1
Operator-1 picks a 1-hour duration job, and the job is from the UK region
The value I enter is 1-UK1234 were
1 is the 1-hour duration of the job
UK - Is the UK region code
1234 - Is the Job ID which is not standard
Then four cells to be highlighted considering each cell a 15-minute duration.
I have also attached the template and given sample data in this and manually highlighted the cells
But I would like to have a VBA code to highlight as many cells depend on the duration and region.
I want green color for the UK region jobs, Blue for the US region jobs, Orange for the AP region jobs, Yellow for Break, and Red for Leave.
Cheers.
|
Are you looking to define, create and color code you task\events individually? Yes?
Download the attached file. Unblock macros from running and open the file.
Dbl_click in in on of the time slot fields for an individual. Fill in the displayed userform or select a range time slot cells for an individual and press CTRL+SHIFT+E (this way your defined duration will auto populate when you select the task code.
BREAK
For any other experienced Excel users - I basically a nub with Excel VBA but got interested in this thread and took a stab at it. The differences between Excel range and Word Range seem legion. I certainly welcome any constructive criticism and any suggestions to improve the code or improve the OP's process.