Message Box showing number of times a certain word followed by a digit occurs first in rows in column

[Ironman]

Hi

Sheet 'Training 1981-1997' Column F2:F6210 contains text, with some rows that start with the word "Day" (without the commas) followed by a space and a number.

I need to cross-check to make sure I haven't skipped or duplicated a number in error. Therefore what I'd be grateful for is some double click event code I can run in any cell in Col G that will return a msgbox that has counted the number of cells in Col F2:F6210 with text beginning with the word "Day" followed by a space and a digit e.g. "Day 123". I've used the 'Find' function to do this so far, but it'll be faster just to double click.

Many thanks!

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[My Aswer Is This]

The word Day followed by a space and a number occurs 389 times (i.e. Day 1, Day 2, Day 3...Day 389)

But your saying the script only shows 9 when run.
Well are you using my script?

 

[Ironman]

But your saying the script only shows 9 when run.
Well are you using my script?

I was able to use Mumps' script because he was able to adapt his code to the other scripts in the sheet so it didn't exit. Unfortunately yours won't run because it isn't adapted to the Exit Sub lines in the other scripts.

 

[mumps]

If my code is not working, please see Post #31.

 

[My Aswer Is This]

I was able to use Mumps' script because he was able to adapt his code to the other scripts in the sheet so it didn't exit. Unfortunately yours won't run because it isn't adapted to the Exit Sub lines in the other scripts.

Well I will move on. I think your getting the help you need

 

[Ironman]

If my code is not working, please see Post #31.

Here's a link to the sheet

Training 1981-1997.xlsm

 

[mumps]

You have another BeforeDoubleClick macro referring to column 1 and column 3. Does this code need to be incorporated into the macro I suggested?

 

[My Aswer Is This]

Personally, I never like it when posters provide a link to their data
Because now only the ones who are willing to download the file see the entire situation see the code.
I never click on links and download files.
But that's just me. I see a lot of requests here on the forum for doing such.

 

[Ironman]

You have another BeforeDoubleClick macro referring to column 1 and column 3. Does this code need to be incorporated into the macro I suggested?

Yes please, that would be great, thank you.

 

[Ironman]

Personally, I never like it when posters provide a link to their data
Because now only the ones who are willing to see the entire situation see the code.
I never click on links and download files.
But that's just me. I see a lot of requests here on the forum for doing such.

Equally I don't understand why some people are convinced there are folk hanging around, waiting to give them a virus. I'm looking for help, so it's not a very good idea for me to give a virus to anyone trying to help me.