Public Style As LineStyles

public LineStyles Style

Field Value

Effect for Microsoft Excel 97 file format (BIFF8):

0-Solid
1-Small Dash (No Equivalent Menu for Excel 2000)
2-Square Dot
3-Small Dash, Square Dot (No Equivalent Menu for Excel 2000)
4-Small Dash, Square Dot, Square Dot (No Equivalent Menu for Excel 2000)
5-Loosely spaced Square Dot (No Equivalent Menu for Excel 2000)
6-Dash
7-Long Dash
8-Dash Dot
9-Long Dash Dot
10-Long Dash Dot Dot
11-Round Dot 

Effect for versions 3, 4, 5, and 7.

0-Solid
1-Long Dash
2-Dash
3-Long Dash Dot
4-Long Dash Dot Dot
5-Pattern 50% Solid (No Equivalent Menu for Excel 2000)
6-Pattern 75% Solid (No Equivalent Menu for Excel 2000)
7-Pattern 25% Solid (No Equivalent Menu for Excel 2000)
15-Transparent (No Line)

Version 2 does not support lines

Reference