I have a form with 10 frames each containing 4 options.
I wish to create a collection of the frames.
I.e. Dim MyFrames as new collection
I can then add the frames, MyFrames.Add FormName!Frame1:MyFrames.Add FormName!Frame2: and so on.
But how do I then reference the options in each frame?
MyFrames.Item(1)?????
I hope this makes sense
Thanks for your help
Dave
Hi Dave and welcome to the forum.
How about attaching a sample workbook with your Userform included. This would give us a good idea of how you have the frames and controls in the frames. This will also give you a much better chance of getting an answer.
To attach a file, click on the "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area.
One test is worth a thousand opinions.
Click the * below to say thanks.
Hi Marvin,
Well I haven't used Excel in quite a few years and I can't work out how to add a frame in Excel 2007. If I still had 2003 it might come back to me. I can export the form into a blank database but I'm guessing I can't upload it to this forum.
So I think I'm stuffed but thanks for trying to help.
You can upload a database. Use the same instructions given and be sure to do a Compact and Repair to make the db as small as possible. It might make good sense to put some dummy information in so that we can see what it actually looks like. I think MarvinP thought you had an Excel spreadsheet and not an Access db.
Give us one more shot.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks