R
Ruth
Hi,
I have done a form and I have included a dropdown button that allows to
select among 6 different values that are predetermined. Now, I would like to
have a second dropdown button that allows to select among 4 different values,
but the issue is that those four values depends on the value previously
selected in the button 1.
In summary, Dropdown1 values (1, 2,3,4,5,6) and for Dropdown2 values as
follow:
- Dropdown1 =1 then a,b,c,d
-Dropdown1=2 then e,f,g,h
......
and so on.
Any idea of how to do this? Should I use a macro that fills in the values
for the second dropdown button once the value for the first one is selected?
Any suggestion on how this code should look like?
I have done a form and I have included a dropdown button that allows to
select among 6 different values that are predetermined. Now, I would like to
have a second dropdown button that allows to select among 4 different values,
but the issue is that those four values depends on the value previously
selected in the button 1.
In summary, Dropdown1 values (1, 2,3,4,5,6) and for Dropdown2 values as
follow:
- Dropdown1 =1 then a,b,c,d
-Dropdown1=2 then e,f,g,h
......
and so on.
Any idea of how to do this? Should I use a macro that fills in the values
for the second dropdown button once the value for the first one is selected?
Any suggestion on how this code should look like?