iWantToLearn
08-30-2014, 06:49 PM
Hi,
I dont know if i need vba to do what i am trying to do but i have been searching on the web for hours and cant find anything usefull.
(my english is still needs some practice but i hope you can catch what i am trying to say :))
What i want to do is:
I have a dropdown list assigned to all cells between A1-A10. So the first thing i want to do is if i select an item in the dropdown list lets say its in cell A1, i want remove that item from the dropdown list (or make it unselectable) so one item can be selected only once in the list . (letme give you an example, lets say the items of the list are X, Y, Z so if you choose X in Cell A1, then you cant choose X in the rest of the cells that have the same dropdown list assigned to.
the other thing i want is lets say i select an item in cell A1 and i want to have a specific value or function in cells B1, C2 based on the selected item. For example lets say if i choose "sum" in the dropdown list i want cell B1 to sum some numbers if i chose "multiplication" i want cell B1 to multiplicate some numbers.
Can you advice me how can i do it? or where should i look for the solution?
Thank you so much for any advices!
br,
Joco
I dont know if i need vba to do what i am trying to do but i have been searching on the web for hours and cant find anything usefull.
(my english is still needs some practice but i hope you can catch what i am trying to say :))
What i want to do is:
I have a dropdown list assigned to all cells between A1-A10. So the first thing i want to do is if i select an item in the dropdown list lets say its in cell A1, i want remove that item from the dropdown list (or make it unselectable) so one item can be selected only once in the list . (letme give you an example, lets say the items of the list are X, Y, Z so if you choose X in Cell A1, then you cant choose X in the rest of the cells that have the same dropdown list assigned to.
the other thing i want is lets say i select an item in cell A1 and i want to have a specific value or function in cells B1, C2 based on the selected item. For example lets say if i choose "sum" in the dropdown list i want cell B1 to sum some numbers if i chose "multiplication" i want cell B1 to multiplicate some numbers.
Can you advice me how can i do it? or where should i look for the solution?
Thank you so much for any advices!
br,
Joco