View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default refedits in a userform control class

Doh ! Of course. Very good Rob!

Best wishes Harald

"Robert Bruce" <rob@analytical-dynamicsdotcodotukay skrev i melding
...

Sorry to butt in so late, but you appear to be heading in the wrong
direction.

To define an accelerator for a refedit (or textbox or other control with

no
caption), place a label on the form next to the refedit, give it a caption
describing the refedit ("Data Range", for example), set the label's
accelerator and then ensure that the label is directly before the refedit

in
the form's tab order. Because a label without an associated event can't

take
focus, the next control in the tab order takes it when the accelerator is
activated.

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.