Arrow Keys No Longer Work in EXCEL

[RJM]

The arrow keys no longer work properly in Excel. I used to be able to
move left/right/up/down with the arrow keys. Now, every time I hit an
arrow key the whole sheet moves. I noticed that the solution for this
on the PC is that the scroll key is locked. I have a MAC - hence no
scroll key (i believe). Any thoughts???

 

[Niek Otten]

Press Scroll Lock one more time

 

[RJM]

On the MAC there is no scroll key to hit.....

 

[Niek Otten]

AHA!
No similar functionality, maybe through software?
Sorry I can't help you any further here!

 

[Jim Palmer]

I don't know if this is related to your problem, but I made an
interesting discovery.

When I had a macro linked to a text box, the arrow keys stopped working
after the "Exit sub" line was reached.

When I had the macro linked to a button, the problem was no longer
encountered.

I would prefer it to be linked to a text box as it can be made to stand
out more than a button.

Sincerely

Jim Palmer

 

[Guest]

Before the macro ends refer to the worksheet to take the focus off the textbox

range("A1").select

 

[Jim Palmer]

Thanks for the suggestion.

I had suspected that the problem required the sheet to be re-activated
however I'm still experiencing the same problem after insertin
"Range("A1").Select before the exit sub line.



answer = Application.VLookup(UPCCode, myRange, 3, False)

' If the vlookup function returns #na because the UPC code is not i
the file then display
' a message and end the program

If IsError(answer) Then
Range("A1").Select
MsgBox ("The UPC code entered is not on file. Try searching b
vendor part # or description")

Exit Sub

End If


Regards

Jim Palme