Implementing color schemes in my project

[webster188]

Hi All,

I have a rather big vba project that is used by multiple users. The different worksheets and userforms all have a uniform look and feel. Used colors are defined by RGB values.

In my current code, the used colors are hard coded. For instance, the background of each userform is set before the userform is displayed.

I now want to store the colors in a worksheet or as a constant in vba so I can refer to these values each time i need to display something. By doing so, I can also easily implement color schemes where the user can select what colors to be used.

What would be the easiest way to implement something like this.

Thank in advance for your help.

 

[thisoldman]

I would declare some global constants. For project-wide scope you put the constants at the top of a module and declare them as public.

Option Explicit

Public Const gAUBERGINE As Long = 3148587
Public Const gMAUVE As Long = 10978487
Public Const gPUCE as Long = 10062028

Sub ColorMePurple()
    ' Code here.
End Sub

I always use all uppercase for constants. For global variables and constants, I use a lowercase g as a prefix.