MWhiteside
New Member
- Joined
- Sep 9, 2014
- Messages
- 3
Hi All,
Is it possible to develop VBA that once a given cell changes value the code creates a counter that counts from 1-50 in a different cell?
Example
A1 = 1
B1 = 1-50
If cell A1 changes to 2 (or any value really) cell B1 starts counting up from 1 to 50. Everytime A1 changes B1 restarts the count.
I'm trying to tie the counter to values that drive a series of charts. As the counter moves up the charts would animate. I found code to create animated charts but it's very taxing to hook the code up to a full dashboard. A simple counter seems much easier but I've never created something like this before.
Thank you
Is it possible to develop VBA that once a given cell changes value the code creates a counter that counts from 1-50 in a different cell?
Example
A1 = 1
B1 = 1-50
If cell A1 changes to 2 (or any value really) cell B1 starts counting up from 1 to 50. Everytime A1 changes B1 restarts the count.
I'm trying to tie the counter to values that drive a series of charts. As the counter moves up the charts would animate. I found code to create animated charts but it's very taxing to hook the code up to a full dashboard. A simple counter seems much easier but I've never created something like this before.
Thank you