![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png) hairyears |
Mon 2012-03-12 21:28 |
|
What's the vbKeyCode constant for the {ANY} key? Thank you: that's not nearly as horrible as I expected it to be...
...Said an Excel developer.
I work on two levels: what's an elegant solution in coding terms; and the ugly questions about how it's actually going to compile and run. The overriding concerns on planet Hairyears are clarity and ease of maintenance - if it was performance, it wouldn't be in VBA! - but sometimes, I need to know what I'm doing, and what's being done for me. And some of *that* is horrible, through and through.
Which in turn means that understanding loops is more than merely coding them, and further reading - like this stuff - is essential. |
|