VBA code to run macro with Enter key

[laguna92651]

I enter an account name in cell Q3
Cell R3 returns the worksheet row for the name in Q3.

R3=IFERROR(MATCH(B3,B8:B986,0)+ROW(H8:H986)-1,"Not Located")

I currently have a button to run a macro, GoToAccount(), to go to the row where the Account name is located.

How can I modify the macro to go to the selected row by pressing the Enter key after I enter the account name in cell Q3? I would still like to also be able to run the macro from the button if desired.

Please Login or Register  to view this content.

Thanks

[JBeaucaire]

1) Right click the sheet tab and select VIEW CODE. This will open the SHEET MODULE for that sheet where event code can be used.

2) Paste in this Event macro into that sheet module:

Please Login or Register  to view this content.

3) Close the editor. That macro will watch cell Q3, anytime you manually edit that cell it will trigger your GoToAccount macro.

[laguna92651]

Thanks, so much, works perfect.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.