Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Dinamic drop down lists
#1
Hi, I am creating a macros where I need to create drop down lists based in information in other sheets + next drop down list is generated from changing current list.
For example, we have list of cars(Audi,Porsche and BMW), now we select Porsche and under this list we need to create(update) new list where Porsche item(911,Speedster etc.) are populated and so on.

I have sheet for each(3) lists
1. just name
2. parent name from list 1, name
3. parent name from list 2, name and some values which is the main values to get when switching those lists

I need some help with creating/adding/updating lists in VB macros!? How to catch some ochange event or what?
#2
This forum is not for Excel.
#3
Hmm, I suppose the idea is the same, isnt it?


Forum Jump:


Users browsing this thread: 1 Guest(s)