VBA control array

    Re: VBA control array


    Thanks Norie. I tried importing the code and kept getting the same error message. I'll use this as a skeleton and build my code around it and see what happens.

    Re: VBA control array


    Zzyzzyth - are you sure you have set these up as per our examples ?


    There seems to be a common issue of the code working on our machines but not on yours, which suggests that you are either changing the code or maybe not importing enough of it.... I notice Norie & I essentially use the same method of removal (which works)... so what are you doing that's different ?

    Re: VBA control array


    I'm not sure. The examples are working great. I'm pulling all of the code and changed all of my variables to match the imported code. The class module with the latest example looks like the exact class module that Norie got me started with, just attached to a different workbook. The only thing I'm doing different (that I can think of) is putting the AddRemoveCheckboxes code in my cbo_Change event. Mainly because I don't know how many to AddRemove until I retrieve the recordset.

    Re: VBA control array


    Interesting. I dumped my code into the workbook that Norie supplied and it works just fine. But, if I import the code from Norie's workbook to mine, I get the '444' message. I don't understand why, but I'll take it! Thank you so much for all of your help. And once again, sorry about the cross-post.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login