| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use Excel to mark student's tests? | Excel Worksheet Functions | |||
| How do you create a check mark in Excel? | Excel Discussion (Misc queries) | |||
| How do I get Excel to do a tally mark total? | Excel Discussion (Misc queries) | |||
| Can I change the "white cross" cursor in Excel to another cursor? | Excel Discussion (Misc queries) | |||
| what does the ! mark mean in an excel formula | Excel Discussion (Misc queries) | |||
Linear Mode
