use active selection from outside

[olwy]

Hi all,
I need to search according a cell out of excel (ERP databases). I found a way: I select it in ERP, press CTRL + C, so I get it in memory. I move to excel and run macro, which paste it on unused cell somewhere down, copy it to excel memory and use it for filtering. How can I avoid these additional steps and use ctrl + C memory immediately?

My code (part in bold should be replaced):

Please Login or Register  to view this content.

Thank you for that. You cannot imagine how much time you can save if you are filtering 300 items. :-)
Petr

[millz]

Try:

Please Login or Register  to view this content.

[olwy]

Looks nice but compile error appear: User-define type not defined. Any idea? Thanks.

[millz]

Maybe you are missing Microsoft Forms object library reference. See here: http://support.microsoft.com/kb/212730

[olwy]

You were right. It is working. Thank you for that.