I have a userform that fills a table cell either red, amber or green to RAG rate reports - something I do a lot, so this is a really good time saver. My issue is that I have to click twice to return to select the next cell. So:

Current cell active, click colour button on userform and it fills the cell (great)


Userform remains active, so I need to click the document away from the userform to gain focus, then click the next cell I want (not so great).

https://www.loom.com/share/c34bdc89d...f-2ffceee0e374