Yes, the reason I looked at this thread is precisely because I keep thinking I should really master VBA - at least for Excel and Word - and I wanted to see what books people recommended.
I was actually toying with buying something along the lines of Excel 2000 VBA Programmer's Reference second-hand from Amazon (
http://www.amazon.co.uk/Excel-2000-V...8097205&sr=1-3) since I already know most of the basics (no pun intended!).
I’ve actually done a fair bit of VBA programming but the main reason I don’t feel that I’ve truly mastered it is that I usually find alternative solutions far too quickly…
…For instance your ‘enter dates without the colons’ is easily done without resorting VBA programming:
- Format Column A as “0000” (so that for instance 410 is displayed as 0410)
- Format Column C as date
- Enter this formula in B1 =REPT(0,4-LEN(A1)) &A1
- Enter this formula in C1: =IF(LEN(A1)=3,"0"& LEFT(A1,1),LEFT(A1,2))&":"&RIGHT(A1,2)
- Then just Edit>Fill>Down (CTRL-D) as many cells down as you need.
That’s it! And no VBA in sight!