Hello everyone,
I'm stuck in my code trying to have one combobox depdendant from another and displaying choices based on a worksheet range.
The range I'm using is a bit particular:
=Validations!$D$2:INDEX(Validations!$D$2:$D$1000,SUMPRODUCT(--(Validations!$D$2:$D$1000<>"")))
This allow me to have my users changing info in the worksheet and the macro adapts automaticaly.
Now it's all good for the first combobox when I set its RowSource to the range in question.
But I can't find a way to make the second combobox dependant from the first one and have it take various ranges from the worksheet.
The last bit of code I have tried is this one:
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. Also your INDENT tags were all applied incorrectly so I removed them.--6StringJazzerPlease Login or Register to view this content.
Validations being the name of the worksheet, GroupType the first combobox and GroupName the second combobox.
The Macro is in the form MeetingAdd at the start of it. I start the macro with the button on the top of the first sheet "Add".
Does is make sense to anyone?
PS: I'm new to VBA so every constructive criticism is more than welcome.
Cheers.
Bookmarks