Change the cursor to a hand? Excel 2003

[cjbrown815]

Hello,
I was referenced to go to the string
thread181-775804: Change the mouse cursor to a pointer

and it explains for access but not excel. I am not well educated in excel. I have a checkbox that I would like to have the cursor change to a hand icon when it is floating over the checkbox.

currently I have this
//
Private Sub CheckBox1_Click()
checkboxstatus = True

End Sub
//
and I'd like to include the cod ein the string above but do not know how.

thank you

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[xlbo]

where does the checkbox sit? worksheet or form ?

you would need to use the mouse move event of the control on a worksheet and the mouseover event on a form

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[cjbrown815]

Its on a worksheet. I need to know exactly how to do it. I've tried and can't figure it out.

thanks,

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[xlbo]

which toolbar have yo used to creeate the control? Forms or Control Toolbox?

It needs to be the latter

right click on control and "View code"
choose "mouse move" from the menu
enter your code



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[combo]

Have you tried the hint in my second reply to your initial post (vb forum)?

combo