vba excel - Parental control multipage userform runtime error 438

I receive a 438 error with this code. It was working before, but since I've added more controls and am ready to publish the userform, I have received this error.

Please Login or Register  to view this content.

I thought it may have to do with disabled and/or invisible text boxes, but after enabling and making them visible, it still errors. I've made a test file and deleted every control except one on each multipage, and it still errors. Does anybody have any suggestions?

Setting up a standard multipage with a few pages and various controls I could not get the line to error.
Userforms can be complex in design but having said that you are specifically targetting textboxes anyway.

What is the purpose of the line? It does not appear to achieve anything and Setfocus took me to the textbox with no data ready for input.

You mention hidden and/or disabled textboxes and to avoid Setfocus errors I would suggest you amend the line
If Ctrl.Value = "" to
If Ctrl.Value = "" And Ctrl.Visible = True And Ctrl.Enabled = True Then

Terriertrip,

This error will be thrown if you have an additional textbox on the userform outside of the multipage control. Could this be the case?

HTH,
Maud

That would be the case. Would I have to create two sets of code for each case?

No, this should do it

Please Login or Register  to view this content.

HTH,
Maud

What is the purpose of the line? It does not appear to achieve anything and Setfocus took me to the textbox with no data ready for input.

From what I've learned, parent of the control is the Page it is on and the Parent of the Control's Parent is the Multipage container object.
There are controls that aren't on on the mulitpage and any other control (within the mulitpage) that is not a textbox has its own targeted code. Only the text boxes are the focus of this line since those are the only area where the unpredictability of user procedures can occur (for the most part) - hence prohibiting empty controls. I've eliminated the the hidden and/or disabled textboxes and the error still occurs, so I'm not sure if the appended code would make a difference.

From what I've learned, parent of the control is the Page it is on and the Parent of the Control's Parent is the Multipage container object.

You are correct above. The added condition will inhibit execution if the Parent of the parent is not the Multipage therefore, any controls that are not textboxes and/or beyond the multipage would be excluded. The code should work as is however, the wisdom of mikerickson is something that you may not want to overlook.

Maud

All right. I thought I was gettin somewhere. Thank you mikerickson for the suggestion. Using Type(Ctrl) vba gives me a compile error expected: expression so I changed it to TypeName(Ctrl) and the compile error resolved. However, even though I ran the below code and worked as intended (even following the tab order!):

Please Login or Register  to view this content.

It errored (now 2110) on the Ctrl.SetFocus because there are also comboboxes on the form as well (I know just enough that obviously it's going to error due to the typename constraint). I do have a branch of code to deal with empty comboboxes. Even more odd to me, after that error, now when I run the code , the code no longer executes. It bypasses and goes straight to my msgbox. I shut down the application and it still no longer executes the code. I feel like I'm falling deeper into the rabbit hole on this

Thanks Ozex. Works perfectly. I appreciate your help.

Glad to help terriertrip. Form management can be frustrating at times.