-
Hi,
I have a series of listboxes that have some info. Once someone selects all of their choices, a chart (mschart control) pops up with a graph. Now, I put in a mousepointer = 11 change when you click on any of the listboxes and then set it back to 0 before exiting the _click subroutine.
Now, when someone sets all the data for the first time, it works, the mousepointer changes, then the graph pops up after a second or two. But...once the chart is up, if someone changes the data to get a new chart...the change of mousepointer doesn't show up. I have no idea what the problem is. I've been setting the change of mousepointer on the form. I tried also setting it for the listboxes and the chart, still doesn't show up after the first time. I also set it for the screen and it still didn't work.
I also have a set of buttons, previous and next (because there is more data that can fit on a chart). I do the same sort of thing with them, set it to me.mousepointer = 11 when you click on the button, call all of the methods to change the chart and then set me.mousepointer = 0...and that works...so why does it work one place and not the other?? Any clue as to what to look for?
thanks
--Dan
-
DoEvents
Hi Dan...
You might want to post a copy of your code so that the VBGurus on this board can take a peek at it. If my suggestion here does not work then you should make another post where you show the code.
My first suggestion is to make sure that you are using the DoEvents function in all of the right places. That function allows Windows to pause execution of the subroutine and update all of the controls on the form, including the mouse pointer. If you don't include the DoEvents function then sometimes your changes will show up when you want them too and sometimes they will not, depending on your code syntax.
The code would look like
Code:
Me.MousePointer = vbHourglass
DoEvents
