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

[Anis.handayni231]

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

[Artik]

You should probably be interested in the OnKey method.

Artik

[PrizeGotti]

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.

[cytop]

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

[PrizeGotti]

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

[cytop]

OK. I'm wrong. The OP was looking to run a procedure without having click a button. The Application.OnKey method is probably one way to do that. Who cares if it is a Method or Event but feel free to shoot down my answer on semantics?