Assign Macro to Cell

Is it possible to assign a macro to a cell? I have it assigned to a button because I have a search feature that automatically extracts matching records. The search button can't be clicked when you are still typing in a name in the criteria bit. Is there any way to assign a macro to a cell to resolbve this>? thanks

You could use a Worksheet_Event but this won't trigger a macro until the editing in the cell has finished. I don't think macros can run while Excel is in editing mode.

Hope this helps

You can assign it to a cell by putting it into a User defined function or UDF.
For this you have to use the VBA editor. Define the Functionname and replace the "SUB" with Function. I hope it works.

Yeb