Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try instead:
Sub lop() For count = 1 To 3 SendKeys String:="={left}-4~{down}" DoEvents Next count End Sub The DoEvents is nice if you want to send keystrokes to more than one cell. It alows time for the cells to accept the keys within the loop -- Gary''s Student - gsnu200720 "hawki" wrote: I assigned a shortcut key to a macro using "ctrl" and a letter. The following "sendkeys string:=" does not function as desired when using the shortcut key. If I run the macro without the shortcut key, the macro runs properly. Is there a remedy so that the macro may run using the shortcut key? The macro line is as follows: Sub lop() For count = 1 To 3 SendKeys String:="={left}-4~{down}" Next count End Sub -- l-hawk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel charts do not update when using SendKeys | Charts and Charting in Excel | |||
Application.SendKeys "%{down}" | Excel Discussion (Misc queries) | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
SendKeys syntax problem | New Users to Excel | |||
SendKeys function | Excel Discussion (Misc queries) |