Macro for OnKey: Can the proc name a VB6 proc?

[im_chc]

Hi,

I want to capture the user pressing "Enter" in excel. If I want to do
so in VB6, like an Excel AddIn project, instead of in VBA, and want a
proc in my VB6 project to be called instead of a macro sub in the VBA,
what can I do?

I know that the OnKey works, but I can only assign it with a VBA sub as
the second parameter of OnKey("~", procName).

Please help! And thanks.

Regards,
David Chan

 

[Chip Pearson]

I think you'd have to have OnKey call a VBA procedure which would
then call your VB6 proc.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com