xlDashDot numeric value

[lezawang]

Hi
I understand that xlDashdot is an excel constant. My question, does it have numeric value? If yes, is there any table shows that all XL?????? in excel with theirs numeric values. Thank you.
++++

Sub mynew()
Workbooks(1).Worksheets(1).Cells(1, 1).Borders.LineStyle = xlDashDot
End Sub

 

[alansidman]

xldashdot =4

Look at this link

http://winbatch.hpdd.de/MyWbtHelp/htm/20110104.Constants.Excel.htm

 

[Rick Rothstein]

Hi
I understand that xlDashdot is an excel constant. My question, does it have numeric value?

You can get the numeric value of any built-in XL or VB constant by typing a question mark (short for the key word "Print") followed by the constant followed by pressing the Enter Key into the Immediate Window in the VB Editor.