For making the transition from Macros to VBA, I found the book  "VBA and
Macros for Microsoft Excel" by MrExcel to be a very smooth transition.

The most important thing for me was a specific project that forced me to
continue seeking & learning.