Ok so I didn't initially use the dependent CC because I have no clue where to add that into the VBA. Making it work for "drug" and "strength" was easy because all I had to do was change the labels in your example.

But how do I make room for 2 more fields? I'm so lost on what to do :/