Just the code probably won't help. I am reading the Microsoft VBA
tutorials on-line  (Very well written--a.k.a. beware of John Doe's,
well meaning, but poor on-line explanations) and learning about where
code can be to execute from elsewhere. The source of some of the
problem (Other than my ignorance) is that the start-point code came
from elsewhere and it has code in Sheet1, ThisWorkbook and
Module1...so things like Private/Public calssification of subs &
fcn's and when something has to be in the same module as something
else is a factor as well. I got the OnKey to work, but it keeps
cancelling itself, so I'm getting close.


It always helps to learn something about the overall scheme of things
instead of jumping right  in, but I got pretty far. Now that I have
much of the code running, reading the tutorial will make more sense.
I usualluy get stuck in explanations like; "select the X option in
the Y bar." to which I can only say:" What the bleep is the Y bar?"