Scrolling Count?

JeanM01

New Member
Joined
Jun 10, 2015
Messages
9
Hello Everyone,

I'm sort've new to Excel and writing code in VBA. I have the following situation: my company tries to make revenue predictions at its many sites (740 sites). We are the midst of creating a forecast method and we'd like to compare the old one to the new one. So currently I have a Spin Button that runs through each site individually and gives me the best predictor. I'd like to count how many times the predictor is named. I.e when I scroll, Pred1 is show, then Pred1 after scrolling again, then Pred2 and so on...So I'd like to know a way or create a macro that could count the total of Pred1, regardless of site scrolled on. Thanks in advance.


Jean
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top