m.paterson1
04-06-2016, 01:06 AM
I am trying to create a macro which will change the sheet tab colour to green when the form is started and red when the form is completed.
I have a Excel book containing 40 sheets labelled 1-40 but these change from job to job
When cell J5 has a date inserted I would like the tab of that sheet only to change to Green.
When the cell J9 of the same sheet has a date entered the tab will now change to Red.
i.e
I J
5 Start Date 6/4/16 (this would be J5) (J5 symbolises that the form has started so sheet tab would change to green)
9 End Date 25/5/16 (This would be J9) (J9 symbolises that the form is now complete so sheet tab now changes from green to Red)
I am recently new to VBA but a quick learner would be grateful if any one solve this for me as I've spent hours on it.
Also First time poster / long time reader.
I have a Excel book containing 40 sheets labelled 1-40 but these change from job to job
When cell J5 has a date inserted I would like the tab of that sheet only to change to Green.
When the cell J9 of the same sheet has a date entered the tab will now change to Red.
i.e
I J
5 Start Date 6/4/16 (this would be J5) (J5 symbolises that the form has started so sheet tab would change to green)
9 End Date 25/5/16 (This would be J9) (J9 symbolises that the form is now complete so sheet tab now changes from green to Red)
I am recently new to VBA but a quick learner would be grateful if any one solve this for me as I've spent hours on it.
Also First time poster / long time reader.