Changing the Mousepointer

[VBAmateur]

hEY i CAN'T GET THIS MOUSEPOINTER DEAL TO WORK RIGHT. When a user clicks a button I first pout in the code
form1.mousepointer = vbhourglass

and at the end of the code for that button I put

form1.mousepointer = vbarrow

and it will not change the mousepointer back to an arrow, small but frustrating. Any Help, Thanks.

[SonGouki]

Try setting the MousePointer back using vbDefault instead of vbArrow. Also, be sure that for every time you change the MousePointer to vbHourglass you return it to vbDefault the same number of times. It works kind of like a counter: each time you turn the MousePointer into a Hourglass the counter gets incremented, therefore you must change it back to its Default the same number of times to return the counter back to 0, which puts the MousePointer back to its original state.

Hope this helps to clear things up.