Amend command button colours via public constants and load event of each form

[theDBguy]

Perfect. Exactly what needed. Thank you all so much. Until next time i get stuck (knowing me a few hours)

You're very welcome. We were all happy to assist. Good luck with your project.

 

[mjdemaris]

Just happened to stumble on this thread while looking for the same answer...
I created three long constants in a public module (Utilities), set values to RGB numbers: 100, 150, 200 for example.
Then created a public function

 ColorTest as Long

Public Function ColorTest() As Long
    ColorTest = RGB(c_Color1, c_Color2, c_Color3)
End Function