How can I change the text (validated from a list of text) in an Excel cell using Excel Form Controls and be able to change from both sides?

Answer 1

Please follow these steps:

1. Choose the cell that contains the text you want to edit.
2. Click on the "Developer" tab in the ribbon menu.
3. Click on the "Insert" button in the "Controls" group, and select "Text Box" under "Form Controls."
4. Click and drag to draw a text box over the cell with the text you want to edit.
5. Press right click on the text box, and select "Format Control."
6. In the "Format Control" dialog box, go to the "Control" tab.
7. In the "Input Range," select the cell that contains the original text you want to edit.
8. In the "Linked Cell," select a cell to link to the text box.
9. Check the "Multi-line" checkbox if you want to be able to edit multiple lines of text.
10. Click "OK" to close the dialog box.
11. Click twice on the text box to activate it, and then type in the new text from either side of the text box.
12. New text will be updated in both the text box and the linked cell.

AND YOU ARE DONE!