How to determine next tabstop in VBA UserForm? -
I have a YouTube form in which there are some text box entry fields which are enabled / disabled by a checkbox I when a checkbox Is clicked to check, I want to move the focus to the now-enabled text box.
The tab box tab option has the next control after the checkbox, so it seems that tab order will be a good idea to find the appropriate text box.
But ... how can I get more control in the tab order after given control? Is there a way to do this, or do I have to calculate the all controls and figure out for yourself?
I appreciate that it comes under the title of "telling all the controls", but it Very simple and I attach the code for perfection:
Private sub-checkbox 1_kick () DM CTL as the control for each CTL I.Controls as if ctl.TabIndex = Me.ActiveControl.TabIndex + 1 then exit for ctl.SetFocus end if the next
ending sub
Comments
Post a Comment