Thread: sendkeys string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hawki hawki is offline
external usenet poster
 
Posts: 27
Default sendkeys string

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