MouseMove event - Change cursor type ?

[liamfitz]

A MouseMove event, triggers when I hover over a control. i've checked this. Does anyone know if I can change the cursor type, from an 'I_Beam' ( not very helpful to indicate to a user they can click on this control ) to a hand ( or whatever ) as it's a control which is clickable to do something else.

 

[boblarson]

It is possible, but I'll tell you this - it is a pain in the butt. You need to use the mouse move of something else to set it back and you would think that you could use the Detail Section's mouse move to deal with it but that isn't completely the case. When you have other controls on that, their Mouse Move events take precedence over the Detail Section. So, you would have to put the reset code in each of those as well.

But just so you know how to do it, it can be done like this:

Screen.MousePointer = 11

11 is the hourglass. Just click somewhere in the text MousePointer, when in the VBA Window and hit F1 and it will bring up the help screen to tell you which options you have available.