Press Enter To Run Macro

[Bmiller109]

I have been looking around everywhere and can't seem to find what I need. I am working in a workbook with three sheets the first of which I have a macro that using a button searches through the entire workbook and reports the matches below the search. I need this macro to run however on the press of the enter button. So when a string to search for is input in cell B2 then enter is pressed, then the macro runs and the results are reported as they are now.

Help would be greatly appriciated.

[ragavan.sridar1]

Hi,

Try using the private sub workbook function, so that when the data is entered/changed in the cell B2 you can call the macro.

see if the code given below works for you..

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$B$2" Then

Call your macro

end if

end sub

[JOHN H. DAVIS]

Maybe:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.OnKey "~", "YOUR MACRO"
End Sub