ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I know if user is pressing a key from the CommandBarButton class (https://www.excelbanter.com/excel-programming/410233-how-do-i-know-if-user-pressing-key-commandbarbutton-class.html)

Torben Laursen[_2_]

How do I know if user is pressing a key from the CommandBarButton class
 
I have a custom menu in Excel written in C#

Now I would like to check if a user is holding down the shift key when he is
clicking on one of my menu's.
I want to use this for hidden advanced features.
The function looks like this:
private void MI_EditUsingDatabase(CommandBarButton Ctrl, ref Boolean
CancelDefault)
{
bla bla
}

But how do I know if the user is pressing a key inside this function?

Torben


Mark Ivey[_3_]

How do I know if user is pressing a key from the CommandBarButton class
 
I am not real sure about this issue, but this link may help out...

http://support.microsoft.com/kb/108357

Mark Ivey

"Torben Laursen" wrote in message
...
I have a custom menu in Excel written in C#

Now I would like to check if a user is holding down the shift key when he
is clicking on one of my menu's.
I want to use this for hidden advanced features.
The function looks like this:
private void MI_EditUsingDatabase(CommandBarButton Ctrl, ref Boolean
CancelDefault)
{
bla bla
}

But how do I know if the user is pressing a key inside this function?

Torben




All times are GMT +1. The time now is 01:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com