run macro although blinking cursor is active in an active cell

B

bartman1980

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conso macro 0
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Get macro to run on all sheets not just the active sheet 2
Data Cleanse Macro Running Very Slow 0
Find value in hiden row 2
Find in Recorded Macro 2
Stop a find after the last occrance of the search value. 9
Name an active cell 1

Top