Count Keywords in Column through Macro in Excel

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

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

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

Need Help with Macro Security 1
Macro to Select text from a point given to a specific word 2
Need Help with a VBA subroutine 0
Excel Macro VBA to Count Google Search Results 0
Word macro that can call cells out of Excel for a find and replace 0
SUMIFS UNTIL the number is repeating 0
Counting rows in a column 5
Linking data in MS Word into Excel 5

Top