| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro although blinking cursor is active in an active cell
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| How do I make it so that the active cell follows the cursor keys? | Excel Discussion (Misc queries) | |||
| How do I move cursor in an active cell without using delete/backsp | Excel Discussion (Misc queries) | |||
| Cursor keys move active cell or scroll screen, how do I select whi | Excel Discussion (Misc queries) | |||
| Writing Macro - How to get the cursor/Active Cell back to top of W | Excel Programming | |||
Linear Mode
