Count Number of Characters in a Selection

[Brawnystaff]

I am using the macro below to count the number of specific character in a cell. The only problem it only counts one cell. How do I modify to display multiple cell counts if more than one cell is selected? Thx.

Please Login or Register  to view this content.

[Amabio]

I'm not sure about the MsgBox option, but you could save the results into an array or collection, then tag them into a Form. The Form could be designed to look like a message box, if you wanted.

If it had to be a MsgBox, then I imagine you could use the same array/collection idea, then build-up a string based on the members. Then, you could add this string into the MsgBox. I imagine it would be kinda difficult to make it look pretty, but you could play with it.

[Amabio]

Using the MsgBox collection idea, something like this may work:

Please Login or Register  to view this content.

If it worked the messagebox should look something like: "Delim Count: [A1=20] [A2=5] ...etc."

[Brawnystaff]

Thanks Amabio. That worked out perfectly!!!

[Amabio]

Glad to hear. Cheers.