View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Alternative to SendKeys for field that' not in tab sequence

It's not in the correct tab sequence because of when it was added to the
UserForm. The TabIndex property controls the order the controls will be
visited in when the Tab Key is pressed.


I meant to add to the above... "The TabIndex is assigned sequentially as the
controls are added to the UserForm; however, the TabIndex can be reassigned
by you, at any time, as necessary".

Rick