I am a noob to VBA coding and was seeking help on how to output a count
of keywords through a message box.

I created a macro for a Excel spreadsheet and want to make a message
box displaying this:

Show a count of "shall" from a column and count of null's from another
column when the Excel spreadsheet is opened.

Thanks!