V
vhrao
I have five options stored in a list at cell $E$20
When user selects say Option1 from the list, I want to get six values
from cells in range $C$24:$E$25 and store it in the first array element
When user selects say Option2 from the list, I want to empty the values
in the cells cells in range $C$24:$E$25 on the worksheet and allow the
usre to key in another six values in the those cells, and store it in
the second array element
.... so on
for all the five options I have to store the values from the same six
cells, in five different array elements.
As you can see, User can supply different values in the same cells for
each option.
Once the values are saved in the array. User exits, reenters, and
selects the option, then I would like to display the appropriate values
in the range $C$24:$E$25 from the array.
I hope I have explained the scenario clearly. I am not very familiar
with vb-excel programming
Can you please give me the VB solution. Thanks
When user selects say Option1 from the list, I want to get six values
from cells in range $C$24:$E$25 and store it in the first array element
When user selects say Option2 from the list, I want to empty the values
in the cells cells in range $C$24:$E$25 on the worksheet and allow the
usre to key in another six values in the those cells, and store it in
the second array element
.... so on
for all the five options I have to store the values from the same six
cells, in five different array elements.
As you can see, User can supply different values in the same cells for
each option.
Once the values are saved in the array. User exits, reenters, and
selects the option, then I would like to display the appropriate values
in the range $C$24:$E$25 from the array.
I hope I have explained the scenario clearly. I am not very familiar
with vb-excel programming
Can you please give me the VB solution. Thanks