Dynamic List Using Indirect Reference in VBA
K
Hi guys,
Good morning,
Please i want some body help me about an issue on VBA
First i have a dynamic list created by INDIRECT Function
I want if i choose one choice from this dynamic list, Excel auto display on the next cell , the sub-list of each choice (LOCATED IN ANOTHER SHEET),
i find this on the web but have some problem at the end
Thank you very much
M
K
Bonjour,
En faite j'ai voulais dire si j'ai choisissais Couleur dans la premiere cellule, excel affiche toutes les propositions a la seconde cellule
comme suit :
Color
Purple
Black
Blue
Green
Grey
Red.
et si je choisissais Size
Size
XS
S
M
L
XL
meme chose pour clothes
merci beaucoup