xth of a total of cells

[Samet1805]

Dear specialists
With the code below I count how many times a certain text (function.caption) occurs in sheet SV-SE, range (D2:D100)

Please Login or Register  to view this content.

Now I want to add a piece that shows how much of a total this is. Is that possible?

example: 2 of 3

thanks in advance

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Richard Buttrey]

Maybe something like

Please Login or Register  to view this content.

[Samet1805]

Dear Richard

Thanks for this but I think I was not clear enough.
Attached you'll find a workbook as an example.

If doubleclick on "Test 1 or Test 2" a userform will be shown.
With the spinbutton I can toggle between the cells with the text in the active cell.

I want in label 2 the total count of the text in the active cell AND the place of the selected cell with this spinbutton.

[Samet1805]

Hello Everyone

Is there a solution for my question?

[Richard Buttrey]

Sorry it's still not clear.

There's no userform with spin button shown.

Please offer some specific examples of what you want to see for various selections/permutations.

ARe you certain you even need a Userform to do this? It seems you're wanting to count stuff which is more easily done with an Excel function.

[Samet1805]

Dear Richard

You have to doubleclick on C2, C3, c4, C5, C6 or c7, then the userform is shown.

for example, if I doubleclick on "test 1" in cell C2, the userform is shown with the label left "test 1" (= the text in C2).
With the spinnbutton, I can can go to the next or previous cell with the same text. In this example C2 to C4.

In the label on the right site, I want to show the total of the cells with this text AND show the numeric place of the cell.
F.e. start is cell C2, so the label must be "1 of 3". If I go to cell C3 with the spinnbutton, the label must be "2 of 3",....

I do more actions with the userform, but fot my question on the forum, I've simplified it a little bit.

[Richard Buttrey]

See attached for one way. Another way would be to hold helper cells on the worksheet that evaluate the item number and position with COUNTIF() functions and read the helper cells into the Label

In the production model you'll probably want to use a dynamic range name to evaluate the number of items and use the range name in the VBA

[Samet1805]

Thx Richard!