mml
08-24-2020, 08:14 PM
Hello
Working to get some things automated .On a basic spread sheet I am required to count the number of times a value is entered onto this sheet. This can run into the hundreds. I have tried to simplify with user form but have not been able to find the VBA code to get the " count " of number of times a value is recorded. eg if 12 is selected from combox then the number of times it has been recorded appears in a corresponding field.
I have seen result via pivot table or via list thought possibly in correctly that this could be done via a userform.
Hoping that this is a simple task ???
Thank you for your time
Working to get some things automated .On a basic spread sheet I am required to count the number of times a value is entered onto this sheet. This can run into the hundreds. I have tried to simplify with user form but have not been able to find the VBA code to get the " count " of number of times a value is recorded. eg if 12 is selected from combox then the number of times it has been recorded appears in a corresponding field.
I have seen result via pivot table or via list thought possibly in correctly that this could be done via a userform.
Hoping that this is a simple task ???
Thank you for your time