Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
do I need ScrollArea and/or??
Hi and many thanks in advance!
I am using the following DLL: Public Declare Function GetAsyncKeyState Lib "user32.dll" (ByVa nVirtKey As Long) As Integer Public Const KeyPressed As Integer = -32767 Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) I have the following macro: Sub Mov_OnTime() On Error Resume Next Do Sleep 10 Select Case KeyPressed Case GetAsyncKeyState(vbKeyEscape): End Case GetAsyncKeyState(vbKeyDown): Move_Down Case GetAsyncKeyState(vbKeyRight): Move_Right Case GetAsyncKeyState(vbKeyUp): Mov_Change Case GetAsyncKeyState(vbKeyLeft): Move_Left Case Else: Move_Down End Select DoEvents Range("A1").Select Loop End Sub so when I press Esc my vba code ends when I press, vbKeyDown) I call then Move_Down macro Move_Down ,Move_Right ,Move_Left are made to move a specific Cell t the right, left and or down eg: Sub Move_Right() If MyBlock(1).Offset(0, 1).Locked = True Then end MyBlock(1).Cut MyBlock(X).Offset(0, 1) End Sub my problem comes because when I press any of this keys without havin the following "Range("A1").Select" code prior the loop end, see th macro above I scroll either down to the right and /or... So I lose the view of my work after a few Move_Down and or Move_Right calls do I have to set up one ScrollArea to avoid this happening an or????????? Just let me kno -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit Scrollarea | Excel Worksheet Functions | |||
ScrollArea | Excel Discussion (Misc queries) | |||
Scrollarea | Excel Discussion (Misc queries) | |||
ScrollArea Property Won't Save | Excel Programming | |||
Activesheet.Scrollarea | Excel Programming |