xlLineStyle

[Martin]

What is the connection between the xllinestyle and the
associated number ie xldashdot = 4 xldash= -4115?

 

[Tom Ogilvy]

xldashdot is a constant that holds the value 4.

 

[Tom Ogilvy]

It doesn't follow any particular structure. The developers chose what the
values are and wrote their code to react to the specific values specified.
The constants are defined in the Excel object library and provided to
developers to as an enhancement to the interface, so you don't have to
remember that if you want a dashed line you would use -4115, but that you
can use the constant xlDash.

 

[martin]

thank you or a good reply!!

-----Original Message-----
It doesn't follow any particular structure. The developers chose what the
values are and wrote their code to react to the specific values specified.
The constants are defined in the Excel object library and provided to
developers to as an enhancement to the interface, so you don't have to
remember that if you want a dashed line you would use - 4115, but that you
can use the constant xlDash.

--
Regards,
Tom Ogilvy




.