Guest_imported
New member
- Jan 1, 1970
- 0
Wonder if you can help....
Ive got 4 'drop down' boxes within excel (on a sheet). They are all context specific. By this, I mean that the options in drop down 1 are set, but depending on what you choose in there will determine what is available in drop down 2, and depending on what you chose in drop down three will determine what is available in drop down 3... and so on.
This I can do, but the problem is that I do not know how many sets of drop downs the user is going to want, they might need 3, they might need 30. Would it be possible to set a command button to dynamically add a new set of drop downs (keeping the context specific function working)??
TIA
regards
Paul
Ive got 4 'drop down' boxes within excel (on a sheet). They are all context specific. By this, I mean that the options in drop down 1 are set, but depending on what you choose in there will determine what is available in drop down 2, and depending on what you chose in drop down three will determine what is available in drop down 3... and so on.
This I can do, but the problem is that I do not know how many sets of drop downs the user is going to want, they might need 3, they might need 30. Would it be possible to set a command button to dynamically add a new set of drop downs (keeping the context specific function working)??
TIA
regards
Paul