coding in personal xlsb

There is probably no "one best, universal answer".

You know, it's personal ;-)

But I can recommend a good text to read:

What would James Bond have in his Personal Macro Workbook? http://chandoo.org/wp/2013/11/18/usi...acro-workbook/

The interesting part starts somewhere in the middle of the text (after intro and instructions on how-to-record-a-macro).