|First, allow me to sort of echo trvlr's point... |
You are trying to use Excel for a purpose that it was not designed for. Excel is a numbers based application, not a text editor. Yes, they built in some text related functions, but they are there more for convenience sake than as a major player.
re: 1. Can you write a text in one cell and select a drop down menu in another cell without jumping/exiting the textcell you are writing the text in?
re: 2. If this is possible, can some code be made, so that the value selected on the drop down menu gets put into the cell you are currently typing text into?
Since it's not possible, what you specifically asked for can't be done. However, there is a possible work around.
Why not have some cells where you manually enter text and other cells with drop downs for your customer data and then a final "output" cell with all the other cells concatenated together?
In A1 you would enter A man named Mr.
In B1 you would have a drop down with a list of names.
In C1 you would enter has a red beard.
In D1 you would have =A1&” "&B1&" "&C1
This would result in single cell with all 3 entries.
A man named Mr. name from drop down has a red beard.
I am aware that this will only work in certain situations, but I'm just tossing it out as an idea.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.