VBA Refline

rholt · Post by **rholt** » Sun Jul 06, 2014 10:51 pm

Afternoon,

I'm having some issues with the refline command in VBA.

Could someone please explain the standard means to define colours other than black. I require red (255,0,0) and Light Grey (192,192,192)

I need to output the following:

Refline(15,5,???,10,-100,"300m curve")

Parameters:
1: draws line on secondary Y2 with label
2: 5 (medium dash)
3: need to specify red and light grey as explained
4: 10 is the line width in 1000ths of inches
5: value
6: legend entry for the reference line. Use "" if you don't want an entry in the legend.

Post by **DPlotAdmin** » Mon Jul 07, 2014 8:13 am

The color values are red component + blue*256 + green*65536. That's a mess to do in your head, but they can be expressed in hexadecimal with a "0x" prefix, which makes it a bit easier. Red=255 can be expressed as 255 or 0xff (not case specific) or 0x0000ff. Your light grey can be expressed as 12632256 (192+(192*256)+(192*65536)) or 0xC0C0C0.