VBA Refresh Workbook When Pressing Enter

[CokeOrCrack]

Is there a way to refresh the workbook every time I press enter?

Thanks

OJ

 

[My Aswer Is This]

Define "Refresh"

 

[CokeOrCrack]

Data tab: Refresh All

The entire workbook

I created a refresh command button with this code:

Sub MacroRefresh()
    ActiveWorkbook.RefreshAll
End Sub

But I want the workbook to refresh upon the enter key instead

 

[NoSparks]

The real challenge here is how to detect a press of the Enter Key on a sheet as an event you can use.

Jaafar has had a couple of threads addressing this. Way over my head, I'd stick with the Command Button.

https://www.mrexcel.com/forum/excel...e-textboxes-w-out-subclassing.html?highlight=
https://www.mrexcel.com/forum/excel...alidating-you-type-into-cells.html?highlight=