VBA Refline
Posted: 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.
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:

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.