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
|