Many people would disagree with you about what's easier, but why don't you
just assign a shortcut key to the macro? Like Ctrl+Shift+R or something?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
"im_chc" <hokching@hotmail.com> wrote in message
news:1137567580.266348.147650@g44g2000cwa.googlegroups.com...
> Hi,
>
> I am developing an application which uses Excel as the input interface.
> I want to use a cell as a "button", i.e. the user can use keyboard to
> navigate to that cell, and press enter to "click" the button. I don't
> want to use a button clicked by mouse, because that would be slow.
>
> However, I can't find any event like "onkeypressed", and
> "worksheet_change" and "worksheet_selectionchange" doesn't do well.
> What should I do?
>
> Thanks in advance.
>
> David Chan
>
Bookmarks