How to tab to a command button?
 

I have 3 or 4 command buttons(from Forms-toolbar) on my excel
worksheet. I would like to give the user the option of 'clicking' the
command button through the keyboard. At this point, i am able to use
the accelerator key and activate the button. But i would ideally like
them to go to the button using the keyboard and then hit the "enter"
button.
Is there a way to do this. Any help would be greatly appreciated.

Thank you very much,

Sameer

How to tab to a command button?
 

How would you know that the tab is meant to go to the button as opposed to
go to another cell?

--
Regards,
Tom Ogilvy

"Sameer" wrote in message
m...
I have 3 or 4 command buttons(from Forms-toolbar) on my excel
worksheet. I would like to give the user the option of 'clicking' the
command button through the keyboard. At this point, i am able to use
the accelerator key and activate the button. But i would ideally like
them to go to the button using the keyboard and then hit the "enter"
button.
Is there a way to do this. Any help would be greatly appreciated.

Thank you very much,

Sameer

How to tab to a command button?
 

That is correct. But say i have a button on a form in cell D4. I would
like to provide a mechanism whereby the cursor moves to the button. So
the cursor could go either behind the button or on the button, depending
on the user's motives..
The accelerator key runs the code behind the button, and i have had
people doing that by accident. Hence, i want them to know whats
happening before they run the code behind the button.

Hope this answers your question.
Thanks
Sameer




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

How to tab to a command button?
 

Again, the user would have to indicate his/her motive with some modification
of the normal movement key. If so, then you are back to an accelerator key.
Even if you tabbed to the key, then it sounds like you want the user to make
another over action to execute the key. All this is really outside the
paradigm of windows.

--
Regards,
Tom Ogilvy

"Sameer B" wrote in message
...

That is correct. But say i have a button on a form in cell D4. I would
like to provide a mechanism whereby the cursor moves to the button. So
the cursor could go either behind the button or on the button, depending
on the user's motives..
The accelerator key runs the code behind the button, and i have had
people doing that by accident. Hence, i want them to know whats
happening before they run the code behind the button.

Hope this answers your question.
Thanks
Sameer




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!