Cursor Shape

[kirkm]

Is it possible to change the Cursor shape from a Cross to (perhaps) a
Hand, or something else, when it is on a particular cell (in a
particular sheet) ?

Thanks - Kirk

 

[Ed Ferrero]

Hi Kirk,

There is no MouseMove event in a worksheet. However, you could put a textbox
control in a cell and set the mouse pointer property to whatever you want.

Can also link a cell to the textbox - handy and no VBA required.

Ed Ferrero
www.edferrero.com

 

[kirkm]

On Wed, 2 Jul 2008 20:33:04 +1000, "Ed Ferrero"

Hi Ed,

Could you give me a bit more info please? I know how to put a text
box on a Form but not into a Cell.

Also, with a link - would that mean if the .xls was used on another
computer that textbox would be missing ?

Thanks - Kirk

 

[Ed Ferrero]

Hi Kirk,

In XL 2003, right-click a toolbar, select 'Control Toolbox' use this to
place a text box in a cell. (Hold the Alt key down whilst placing/resizing
the text box to get it to align to the cell borders.)

In Xl 2007, go to the Developer ribbon, Insert -> ActiveX Controls -> Text
Box. (If you can't see the developer ribbon, go to Excel Options to show it)

Whilst in design mode (the set-square toolbar button is activated), click
the properties button. Here you can change tha mouse pointer, background
colour, border, cell link, and a bunch of other stuff.

All your changes are stored with the sheet, so send to other computers at
will...

Ed Ferrero
www.edferrero.com

 

[kirkm]

On Thu, 3 Jul 2008 13:52:08 +1000, "Ed Ferrero"


Hi Ed,

Thanks for all the info. I did get it working, but it's sort of
strange. A d-click breaks to an empty sub, a single click puts
6 dots around it, kind of spoling the apperance. And no matter
what Mouse pointer I choose, all I got was the 4 pointing arrows
shape. I might just stick with what I had!

Thanks anyway, I didn't know about the control toolbox.
Cheers - Kirk