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:
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,Please Login or Register to view this content.
-Rokn
Bookmarks