Count Keywords in Column through Macro in Excel

[Dafinga]

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!

[Jim Thomlinson]

Here is code to count the nimber of instances of the word shall in column A...

MsgBox Application.WorksheetFunction.CountIf(Columns("A"), "Shall")

Are you looking for the word "Null" or are you looking for blank cells???
--
HTH...

Jim Thomlinson


"Dafinga" wrote:

> 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!
>
>

[dafinga]

Jim,

Looking for blank cells

Thanks!