Cleaner code for looping through userform controls (beginner)

I have a UserForm containing two Frames with 3 combinations of visibility/invisibility.
I have 3 separate codes to control which empty ComboBox takes the SetFocus. (see code below)
I did it this way to address the errors that were being thrown by the empty ComboBoxes in the invisible Frames.

My question is in two parts.
1. How can I make the 3 separate codes into 1?
2. What modification will I have to make when I have a UserForm with both ComboBoxes and TextBoxes?

I would appreciate help from anyone who takes the time.

'When Frame2 is invisible

Please Login or Register  to view this content.

'When Frame1 is invisible

Please Login or Register  to view this content.

'When both Frames are visible

Please Login or Register  to view this content.

Frame is just another control so you can condition test it

2.
you cannot set focus to both control box and/or text...only 1 thing can have focus? so not sure what actually want to do

anyways i setup a little test file so you can see two things
frame visible switching and focus swapping via command button

Please Login or Register  to view this content.

This code expands on that posted by humdingaling.

I moved the setfocus loop into a function which you can pass the parent control and the type of control you want to have focus. Note this currently only works for controls that support the Text property.

Please Login or Register  to view this content.

That's one of the best Thank Yous I seen in awhile. You're welcome.