ooh- questions, lots of em-
good.
1-why the dbl backslash? never seen that convention before- is it a VBA thing or what?
Lisp uses backslash as an indicator for special functions so if you want a backslash to work as a backslash, you have to double it. You can also use a single foreslash in lieu of backslashes for paths in lisp.
2- why does this routine see an esc as an enter? it's non-interuptible when set to the msg box version
It's not actually seing esc as enter, when you hit esc, you cancel the message box and the command continues on. If you want to be able to cancel the routine, you first have to tell the program what cancels the program.
3-when it is set to the Debug.Print it doesn't. print, that is. or do anything observable except pause. all those sums are inside somewhere, but I don't know how to retrieve them.
It "prints" to the "Immediate" window in the IDE. If the Immediate Window isn't showing, you can make it show in the view menu. Something that you need to decide is what result you want. The message box is not what you want I'm sure, nor the immediate window, but do you want it to write to a file or what?
4-units- what does it take to override the default decimal summation ILO architectural?
That's a little more involved. VBA doesn't do fractions so if you want the result in feet-inches-fraction, you need to do replace the decimals with fractions. A function would be a good way to achieve this.
5-what is the best book to buy? keeping in mind (a)-I haven't seen anything about programming since BASIC in high school and (b)-sometimes if I don't feel like I'm getting a clue, I have the attention span of a, well, a mosquito!
For VB(A) in General, I would recomend
O'Reilly's VB(A) In A Nutshell. For AutoCAD specific VBA, I would recomend
Joe Sutphin's AutoCAD 200x VBA: Programmer's Reference