Solved: Updating Charts in VBA with listbox

Quote:

---

Originally Posted by f2e4

I created a Forms scroll bar and linked that to a hidden cell on my page - rather than creating code to use under scrolbar1_change()

---

Is there any disadvantage in using a Forms scrollbar on a sheet rather than an Active X scrollbar?

Quote:

---

Originally Posted by f2e4

This is an example of my scrolling bar using the code above

See attached file

---

The spinner just doesn't feel right does it, shame about the scrollbar. If I get a chance I am going to look again at why that fails.

With a forms scrollbar, I couldn't assign a linked cell so had to go with an activeX scrollbar.

Seeing as other people will be using this, and most have a tendency to scroll from left to right very quickly rather than click once, the whole code crashed.

I'm having real trouble with the second listbox now.

I can get the chart to update when i click on one of the values, but the scrollbar seems to be solely linked to the first listbox (listbox1). So when I click to advance a week, the chart updates back to the previously selected Listbox1 value.

There must be anopther way of getting the scrollbar to advance one week at a time rather than run the whole code everytime.....

Have you seen this thread?