Textbox populated by criteria of columns data

[savyback]

Dear all,
i need simply a code to get a count of each element of column "D" (how many of "SA", and "MI" and "PA" ecc...), each result type should appear respectively in each testbox.
It could be simple, but i'm beginner of vb excel..so i kindly ask your help..
Hopin

Thank you in advance
Salvatore

[cupitron]

Hi savyback,
Why don't you use a pivot table? Do you need the VBA code? If not, please see attached...

Cheers,

temp1.xlsm

[savyback]

Hi Cupitron, unfortunately i need code for a form. I know that it's more simply getting it with pivot table, but the attached example is a part of a big project (with other data) entirely developed with vba/form.
Moreover it could be fantastic getting a pivot table on a form!
Greeting from Milan (I) !!
& Thank's in advance!

[cupitron]

Hi Cupitron, unfortunately i need code for a form. I know that it's more simply getting it with pivot table, but the attached example is a part of a big project (with other data) entirely developed with vba/form.
Moreover it could be fantastic getting a pivot table on a form!
Greeting from Milan (I) !!
& Thank's in advance!

Hi savyback,
Create a new module in VBProject and insert the following code.
I also removed your code that calls the UserForm under "Questa_cartella_di_lavoro" just so this is all in one module, but you can put it back there if you wish. You must comment out that code first before attempting to run this, otherwise you will get an error.

I also added a button on the Figlio1 sheet to show the form.

Please Login or Register  to view this content.

The number of Provincia Abbreviations is dynamic in the search but it will not generate new ComboBoxes on the UserForm for additional provincia...
In case you can't get the code to work, I've upload my edited version of the file.

I hope this helps.

Cheers,
-Dan

[savyback]

Hi Dan, thank you very very much you gave me the right solution!!
You are very helpful!
I'll keep this code carefully for future developments..

Ciao
Salvatore

[cupitron]

Not a problem!
I'm glad that I could help.

Cheers.

[savyback]

Hi Dan,
please if you can, i have a problem.. Enclosed you find a simply xls file has a field to search customer.
I should get the customer's name also by inserting a part of the name, actually the system requires that i insert the totally and exactly customer's name.
Is there a way to modify or add a part of code to get a solution?
Thank you in advance for your usually courtesy..

[cupitron]

Hi Dan,
please if you can, i have a problem.. Enclosed you find a simply xls file has a field to search customer.
I should get the customer's name also by inserting a part of the name, actually the system requires that i insert the totally and exactly customer's name.
Is there a way to modify or add a part of code to get a solution?
Thank you in advance for your usually courtesy..

Hi Savyback,

Please post this in a separate thread, since this thread has already been "Solved".
I did not look at this until now because you labelled it "Solved".

Thanks,