Looping through controls by frame on userform (frame within a frame)

**njs27** · 03-26-2015, 06:38 PM

Hi all!

Thanks for the help the other day.

So I have this form:
framesIssue (2).jpgwhere I'm trying to loop through the controls frame by frame to capture the values the user has chosen. I have added the name for each frame to the picture so it is easier to follow the code. The problem is that when it gets to the "Timeframe" frame, which is a frame around both the Fiscal Year and Quarter of the year choices, it gives me a type mismatch error. I think this is because they are embedded frames? Like, it thinks it should be looking for "fr2" and it encounters frTimeframe and doesn't know what to do? I thought that by naming it "frTimeframe", Excel would ignore that frame and just go to the next one. It loops through the first frame with no problem and writes the correct data to the worksheet (this is obviously a snippet of the code). Can anyone help?

Please Login or Register  to view this content.

Thanks!!
-njs

**gmr4evr1** · 03-26-2015, 06:52 PM

I may be wrong, but I think it has to do with the

Please Login or Register  to view this content.

You've defined the fr 1 through 4, but not the frTimeFrame and the

Please Login or Register  to view this content.

is telling it to look for anything with fr & xitem (in this case 1 to 4) after it. frTimeFrame meets the 1st part of the criteria, but not the 2nd so it doesn't know what to do with it. Try taking the fr off the frTimeFrame and see what happens.

**njs27** · 03-26-2015, 08:14 PM

Thanks! It worked! (although I don't really understand why it doesn't skip over it since it doesn't follow the format, but I'll just go with it)

**gmr4evr1** · 03-27-2015, 10:21 AM

You are welcome, glad it worked. Basically it comes down to if the xitem is 1, 2, 3, or 4 after the "fr", it knows exactly what to do. Anything else after "fr" hasn't been defined, so it has no clue what to do with it and errors. It doesn't skip over it because there is nothing in the code to tell it to ignore it if it isn't fr & xitem