Dynamically SetFocus to next TabIndex control

[mikeymay]

I have a user form that contains a MultiPage control and within in each page there are a number of textboxes.

I have managed to write the code to get the TabIndex of currently active control

strMeasure is the label of the currently active control (textbox)

intTabIndex = frmDataEntry.mpMeasures.Pages(frmDataEntry.mpMeasures.Value).Controls(strMeasureLabel).TabIndex + 1

I am now struggling to focus on the next control(text box) using the intTabIndex variable.

TIA

 

[skorpionkz]

I would suggest to read article "Breakthrough in the Pseudo-Control-Array" by K.Tsunoda.

This will actually "map" all your userforms and allowed to run Code whenever your field got or lose focus.
I use it in the tool I am building and it is quite handy.

https://www.mrexcel.com/forum/excel-questions/856611-subclasses-userform-controls-2.html

Regards,
Andrew