Count Keywords in Column through Macro in Excel

  • Thread starter Thread starter Dafinga
  • Start date Start date
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

modified date of the file 3
Counting Bordered Cells 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
How activate "NUM" thingie? 10
Row and column count last occupied cells in range 2
Counting rows in a column 5
help saving trees by excel *free* macro... 1
counting values in a column 1

Back
Top