Excel mark cursor
 

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

try:

Sub tst()
Application.Cursor = xlNorthwestArrow
MsgBox ("")
Application.Cursor = xlIBeam
MsgBox ("")
Application.Cursor = xlWait
MsgBox ("")
Application.Cursor = xlDefault
End Sub


"Joe" skrev:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

Can that work for any worksheet when I open it?

"excelent" wrote:

try:

Sub tst()
Application.Cursor = xlNorthwestArrow
MsgBox ("")
Application.Cursor = xlIBeam
MsgBox ("")
Application.Cursor = xlWait
MsgBox ("")
Application.Cursor = xlDefault
End Sub


"Joe" skrev:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

well i ges so but not sure

by the way do u get a NorthwestArrow ?
i dont - just getting a standard arrow !


"Joe" skrev:

Can that work for any worksheet when I open it?

"excelent" wrote:

try:

Sub tst()
Application.Cursor = xlNorthwestArrow
MsgBox ("")
Application.Cursor = xlIBeam
MsgBox ("")
Application.Cursor = xlWait
MsgBox ("")
Application.Cursor = xlDefault
End Sub


"Joe" skrev:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

Do you mean instead of the fat white cross?

I have never heard of a method to change that in Excel.


Gord Dibben MS Excel MVP

On Tue, 15 May 2007 08:50:00 -0700, Joe wrote:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

I dont get any arrow. How can i get one?

"excelent" wrote:

well i ges so but not sure

by the way do u get a NorthwestArrow ?
i dont - just getting a standard arrow !


"Joe" skrev:

Can that work for any worksheet when I open it?

"excelent" wrote:

try:

Sub tst()
Application.Cursor = xlNorthwestArrow
MsgBox ("")
Application.Cursor = xlIBeam
MsgBox ("")
Application.Cursor = xlWait
MsgBox ("")
Application.Cursor = xlDefault
End Sub


"Joe" skrev:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

1.where do i need to enter the code below so it works everytime i use a excel
spreadsheet. I am afraid I will need all the steps.
2. So i do CTL+F and the celll will be brought up


"excelent" wrote:

well i ges so but not sure

by the way do u get a NorthwestArrow ?
i dont - just getting a standard arrow !


"Joe" skrev:

Can that work for any worksheet when I open it?

"excelent" wrote:

try:

Sub tst()
Application.Cursor = xlNorthwestArrow
MsgBox ("")
Application.Cursor = xlIBeam
MsgBox ("")
Application.Cursor = xlWait
MsgBox ("")
Application.Cursor = xlDefault
End Sub


"Joe" skrev:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

Lets make a test to se if u can use any of the 3 choises u get

1. In ur sheet type ALT+F11
2. copy my code and select InsertModule Paste code here
3. In ur sheet type ALT+F8 and select tst and Run

macro show the 3 arrow-type u can get
and finaly reset to normal

post me back if u can use som of the 3

"Joe" skrev:

1.where do i need to enter the code below so it works everytime i use a excel
spreadsheet. I am afraid I will need all the steps.
2. So i do CTL+F and the celll will be brought up


"excelent" wrote:

well i ges so but not sure

by the way do u get a NorthwestArrow ?
i dont - just getting a standard arrow !


"Joe" skrev:

Can that work for any worksheet when I open it?

"excelent" wrote:

try:

Sub tst()
Application.Cursor = xlNorthwestArrow
MsgBox ("")
Application.Cursor = xlIBeam
MsgBox ("")
Application.Cursor = xlWait
MsgBox ("")
Application.Cursor = xlDefault
End Sub


"Joe" skrev:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

Sub tst()
application.cursor = xlnorthwest arrow
end sub

sub untst()
application.cursor = xldefault
end sub


Cursor Property

Returns or sets the appearance of the mouse pointer in Microsoft Excel.
Read/write XlMousePointer.

XlMousePointer can be one of these XlMousePointer constants.

xlDefault The default pointer.
xlIBeam The I-beam pointer.
xlNorthwestArrow The northwest-arrow pointer.
xlWait The hourglass pointer.


Gord


On Wed, 16 May 2007 01:17:00 -0700, Joe wrote:

I dont get any arrow. How can i get one?

"excelent" wrote:

well i ges so but not sure

by the way do u get a NorthwestArrow ?
i dont - just getting a standard arrow !


"Joe" skrev:

Can that work for any worksheet when I open it?

"excelent" wrote:

try:

Sub tst()
Application.Cursor = xlNorthwestArrow
MsgBox ("")
Application.Cursor = xlIBeam
MsgBox ("")
Application.Cursor = xlWait
MsgBox ("")
Application.Cursor = xlDefault
End Sub


"Joe" skrev:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks

Excel mark cursor
 

1. Store it in a general module in your Personal.xls file so's it is available
for all open workbooks.

For more on Personal.xls see here.............

http://snipurl.com/1kugy

2. CTRL + F brings up the Find Dialog box. What cell are you referring to?


Gord

On Wed, 16 May 2007 01:24:04 -0700, Joe wrote:

1.where do i need to enter the code below so it works everytime i use a excel
spreadsheet. I am afraid I will need all the steps.
2. So i do CTL+F and the celll will be brought up


"excelent" wrote:

well i ges so but not sure

by the way do u get a NorthwestArrow ?
i dont - just getting a standard arrow !


"Joe" skrev:

Can that work for any worksheet when I open it?

"excelent" wrote:

try:

Sub tst()
Application.Cursor = xlNorthwestArrow
MsgBox ("")
Application.Cursor = xlIBeam
MsgBox ("")
Application.Cursor = xlWait
MsgBox ("")
Application.Cursor = xlDefault
End Sub


"Joe" skrev:

HI, Would it be possible to get an arrow or similar (eg pointer) when u have
the cursor over a cell in excell. SAP does allow a similar feature but it
doesnt seem to have it in excel. Any ideas? thanks