+ Reply to Thread
Results 1 to 5 of 5

Cycle through all userforms in workbook

  1. #1
    Registered User
    Join Date
    07-14-2013
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    35

    Cycle through all userforms in workbook

    Good morning all. I am trying to find a quick and easy way to analyze all of the options on all of my userforms by calling on them and then building a list of all caption names of any check box within said userform. I've tried a couple of different methods and alas have fallen short of a solution that works. The code below results in a run-time error '438'. I'm thinking that there may be something wrong with my syntax in how I'm referencing the userform.

    Please Login or Register  to view this content.

    If I just want to see the name of the userform and hence change my code to the following, it seems to work just fine:

    Please Login or Register  to view this content.
    So, it at least seems apparent that how I'm trying to apply logic to the object once it is called up is not working. If anyone has a solution to this, I'll owe you big time as each of these userforms (there are many) have many multiple checkboxes that need to be checked for updating. I've looked around for a while and not found anything that specifically tries to analyze the userforms attributes once it has been identified. Thank you in advance,

    -Rokn
    Last edited by Rokn; 06-27-2018 at 09:01 AM. Reason: Missing variable dimension

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Cycle through all userforms in workbook

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 06-27-2018 at 09:37 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Cycle through all userforms in workbook

    May be
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  4. #4
    Registered User
    Join Date
    07-14-2013
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Cycle through all userforms in workbook

    The prize goes to YasserKhalil on this solution. Alpha Frog, I had tried your method prior, but for some reason, it doesn't really do anything. Not sure why, but in either case, I appreciate both recommendations. This was a super fun exercise and I see that there are g other projects that will benefit from the application of this solution. Thank you both for your help. Happy hunting!

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Cycle through all userforms in workbook

    You're welcome. Glad we can offer some help for you
    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 08-25-2017, 03:46 AM
  2. [SOLVED] Share Workbook and Userforms
    By esaban in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 07:12 AM
  3. Saving a workbook with userforms
    By ScotyB in forum Excel General
    Replies: 2
    Last Post: 02-13-2014, 04:56 PM
  4. [SOLVED] Cycle through Worksheets In Workbook & Copy Data to Another Workbook
    By DDM64 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-08-2013, 04:15 AM
  5. Cycle throught Text Boxes in UserForms
    By tom.hogan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2011, 11:44 AM
  6. macro to cycle through randomly named worksheet in workbook
    By benji* in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-25-2011, 05:15 AM
  7. Replies: 0
    Last Post: 07-27-2006, 03:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1