Hi Macropod, thank you for replying.



Apologies for putting the question on the wrong thread, it's my first time on a forum!

I'm attaching the word document. The code below works fine for the drop down box called "CC" but I don't know how to do another set of code for the drop down box "Summary". Hope this makes sense. I do not really have an idea of how to do the second one but I have tried copying and pasting the same code (but edited to refer to "Summary") into the same screen as the first one and also into another module screen.

I didn't make up the colours but got them from here: https://github.com/OfficeDev/VBA-con...ration-word.md and they all seem to work fine Maybe word is just interpreting them for me but they all come up as slightly different.

Attached Files

GP.1202.F02 Environmental Monthly Site Inspection X.docm (115.1 KB, 27 views)