I have a Multi-Page Userform and I've been able to test the userform many times, then suddently yesterday I get this "run-time error '381': Could not set the List property. Invalid property array index."
I'm not sure why I am now getting this. I made changes to the form yesterday, but not changes to anything to warrent this problem. Now I can't even test this form, let alone use it.
Please help.
Here is the code that the debug takes me to.
Please Login or Register to view this content.
Are there any candidates listed on CandidateData?
If there are how many?
If posting code please use code tags, see here.
one. I had tried to enter three, but I had done it wrong. I had entered a candidate's data and didn't press add/update because I wanted to see if it would work to enter a second and third and then finally press add/update. But that didn't work. It only added the one. I was just playing around to see how the form is working. So, just one candidate.
Only one candidate is the problem, not the code.
You need to adjust the code to check for the no of candidates.
If there is only one candidate use AddItem, if there's more than one use List.
How do I adjust the code to accomodate that? What do you mean by using List if there is more than one?
The code already uses List t populate the combobox.
List won't work if there's only one candidate.
Try this, but be warned this is roughly written code and is probably prone to errors - don't have IntelliSense on my phone.
Please Login or Register to view this content.
That seems to have worked. I tested it by entering one candidate name and information and clicking add/update. Then, I closed the box and reopened it using my macro box on the form to re-open the userform and it opened just fine. Thank you
So, this error was showing elswhere, but now it's showing under the frmPrintCand.... what could be the problem.
Changing Attachment, please use this one.Please Login or Register to view this content.
ComboBoxPrintBox_TroublesV10.xlsm
Last edited by eemiller1997; 12-20-2012 at 11:46 AM.
It's been figured out. Yay!
The changes in red were necessary:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks