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

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

>
> 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

On Wed, 2 Jul 2008 20:33:04 +1000, "Ed Ferrero"
<ed@edferrero_remove_.com> wrote:

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


>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
>
>>
>> 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) ?

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Wed, 2 Jul 2008 20:33:04 +1000, "Ed Ferrero"
> <ed@edferrero_remove_.com> wrote:
>
> 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
>
>
>>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
>>
>>>
>>> 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) ?

On Thu, 3 Jul 2008 13:52:08 +1000, "Ed Ferrero"
<ed@edferrero_remove_.com> wrote:


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


>
>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...