Is there a list of ForeColor codes?

  • Thread starter Thread starter Rachel Garrett
  • Start date Start date
R

Rachel Garrett

I'm trying to find something like a list that will tell me what number
to type into VBA when I want to see what color. The following code
works, but I need a darker green:

If Me.[status].Value = "Achieved" Then
Me.criteria.ForeColor = 4259584
Else
Me.criteria.ForeColor = 0
End If

I found a list of the 8 basic colors, but I believe that there are 40
available.

Thanks!
Rachel
 
I found a list of the 8 basic colors, but I believe that there are 40
available.
Click to expand...

Actually, there are millions. Your best bet may be to open the properties
sheet for one of your controls, find the Fore Color property, open the
color picker (click the elipse to the right), then click on Define Custom
Colors. Play around with it until you get a color you like. When you close
the color picker, the number associated with that color will be listed in
the Fore Color property.
--
_________

Sean Bailey


Rachel Garrett said:
I'm trying to find something like a list that will tell me what number
to type into VBA when I want to see what color. The following code
works, but I need a darker green:

If Me.[status].Value = "Achieved" Then
Me.criteria.ForeColor = 4259584
Else
Me.criteria.ForeColor = 0
End If

I found a list of the 8 basic colors, but I believe that there are 40
available.

Thanks!
Rachel
Click to expand...
 
Actually, there are millions. Your best bet may be to open the properties
sheet for one of your controls, find the Fore Color property, open the
color picker (click the elipse to the right), then click on Define Custom
Colors. Play around with it until you get a color you like. When you close
the color picker, the number associated with that color will be listed in
the Fore Color property.
Click to expand...

Cool! I didn't know about the color picker.

Thanks,
Rachel
 
Back
Top