ok, I think I've made some good progress in understanding this.
I've changed the names of the variables (based on what I think they are and what values they are holding, for what purpose). Have also heavily indented to help me
concentrate on one bit at a time.
It might have taken me a while but I'm getting there. I think that I'll be ok with working out the next sub after this one as I think that it's essentially doing the
same thing as the one below (but for the second combobox). However, I am a bit stuck on what is going on with that collection (foot of the code block below).
As a recap I have 3 comboboxes in a userform that should list Order number, part number, quantity. I need them to 'cascade'. So selecting order number 1 in combobox1
then populates combobox2 with only those parts that are 'in' order number 1
I continue to be very grateful for any and all assistance.
Thanks,
NoobyNoobyNoob
Bookmarks