The following string (Const) is changed in the code before I compile the program. The number of colors can change (I change these color in code before shipping app). Is there a way I can code the 'With cboStation' to account for any changes I make to the number of items I add to the CONST string. You'll notice that the string has four (4) items, but the With statement (in its present state) can only handle two (2)items. Is there a way to do a LOOP? or something?
Public Const gcon_strStations As String = "Blue:Red:White:Green"
Dim array_Stations() As String
array_Stations = Split(gcon_strStations, ":")