View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default run macro although blinking cursor is active in an active cell

No. Macros cannot run while the application is in Edit Mode.

Mike F
"bartman1980" wrote in message
...
Hi there,
Can you run a macro although the cursor is blinking in an active cell?

I made this very simple search macro, but the user has to get out of
the cell before the macro can run.
Can this be solved?

Sub search()
Cells.Find(What:=Range("B5"), After:=ActiveCell, LookIn:=xlValues,
LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False) _
.Activate
End Sub