anyone know VBA code just press enter, data will appear?

so i've just make filter based on VBA Code, but for show the data i must press command button
maybe there are VBA Code to show data without press command button but just press enter?

thank you before

You should probably be interested in the OnKey method.

Artik

OnKey/KeyPress events only work on UserForms. You will need to call in an API if you wish to use them on a WorkSheet.

Alternatively you can create a stand alone macro to perform the action, and then use Excels built-in ability to bind macro to a keyboard shortcut.

Originally Posted by PrizeGotti

OnKey/KeyPress events only work on UserForms...

Sorry, but disagree. Application.OnKey is available on a worksheet. Obviously it needs to be assigned (and cleared) with code but it can be used as long as Excel is not in edit mode

Application.OnKey isn't an event, it's to listen while a macro is running. Ideally you don't want the macro running constantly.