Cannot get past Run-time 70, Permission Denied

[Mordred]

Hi all,
I just opened a file I was working on last night and when I stepped through the code, which is

Please Login or Register  to view this content.

I am now prompted with an error at the AddItem line telling me that my permission is denied, run-time 70. What's this about, any ideas?

Regards:

[Mordred]

See, this is what happens sometimes when one stays up waaay too late at night working. I'm trying to add items to a combo box change event! 'Geez, and I sat there this morning stumped by why the combo box was not populating.

This still doesn't explain the lack of permission, or does it?

[shg]

Was the ListFillRange property of the combobox set at design time? If so, I think you're not going to be able to use the AddItem method.

[Mordred]

It looks like I did that at work yes. Thanks for that shg, what I did was a straight copy paste of the sheets to another workbook and now I can work with it again.

Just to clarify then, if I set the ListFillRange properties before hand in the properties window and then try to change it with code, the properties window settings will trump the code?

[shg]

Conceptually, if the control has a fill range and you add an item, then the item would have to get added to the end of the range and the range adjusted accordingly (a lot to expect), or the fill range has to get converted to a list and the item added (also a lot to expect, IMO).

You could do either of those in code, though.

[Mordred]

Thanks shg, ideally, I would prefer to do it with code as I like to code. I'll just have to watch that I don't go crazy in the properties window for each object that I use.