Re: VBA control array
Zzyzzyth
See the attached file.
Re: VBA control array
Zzyzzyth
See the attached file.
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
No errors here Norie. Works fine on 2003/XP Pro (as did mine)
I think Zzyzzyth might have some other issues :?
Re: VBA control array
Is there any chance you could attach a sample workbook?
Are you sure the error is being caused by adding/removing the checkboxes?
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
Could you please at least post your current code?
Re: VBA control array
Just a thought... try using after_update
Re: VBA control array
Do I need a specific reference to an Object Library maybe? I'll try the After_update next.
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.
Don’t have an account yet? Register yourself now and be a part of our community!