Posts by Saggaf2012

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    I haven't used VBA before I just used it recently to create an Automated Entry Form in excel for a current project in my work following a tutorial on Youtube. However, whenever I run the code I get an error (Run-time error 381: Could not set the error property. Invalid property array index) which appears to be due the number of columns in my worksheet (16) and it is supposed to be less than 10 to work with the list function ( that is what I understood after googling the error code.).

    While searching for a solution on internet I found a suggestion of using another method (arrays) rather than using lists. However, I couldn't understand how it works. I would appreciate it if any one can help me overcome this problem.

    Attached is a copy of the excel file.