Hy ..
I created in Excel new combo box on Sheet1 and now I have some list of fruit on the second list (sheet2). And it's ok, and works fine when you want data displayed in the combo box,
Now my question is how can I make in the combo box and allow him to enter new data (list of fruits) and save them on sheet2.
Here is an example.
I have a list of fruit on sheet2, on sheet1 is combobox and in that combobox I want to input some new fruits that will be saved when I press enter to sheet2 where is other fruits ...
Here is an example of my Excel, but this must be only modified with input (saving)..
So I will be gratefull is someone help me with these
Example:
I created in Excel new combo box on Sheet1 and now I have some list of fruit on the second list (sheet2). And it's ok, and works fine when you want data displayed in the combo box,
Now my question is how can I make in the combo box and allow him to enter new data (list of fruits) and save them on sheet2.
Here is an example.
I have a list of fruit on sheet2, on sheet1 is combobox and in that combobox I want to input some new fruits that will be saved when I press enter to sheet2 where is other fruits ...
Here is an example of my Excel, but this must be only modified with input (saving)..
So I will be gratefull is someone help me with these
Example:
Code:
https://drive.google.com/file/d/0B98PsNis6dRgQW55Tks5VENEVGM/view