Hi,
I have created a userform with a textbox for the user to enter text information on a specific location. When they click the 'enter' button on the userform the text is entered into the relevant active cell.
The issue I am having is that the text that is actually displayed in the cell is at the end of the sentence rather than at the beginning.
I.e. If a user entered "London W1A 2BE - Go to Green Door" then "to Green Door" is what is displayed in the cell instead of "London W1A"
I have checked to properties of the textbox and the formatting of the actual cell and I just can't figure out why it is doing this.
could someone offer me any advice on how to resolve this please?
Many thanks
Paul
I have created a userform with a textbox for the user to enter text information on a specific location. When they click the 'enter' button on the userform the text is entered into the relevant active cell.
The issue I am having is that the text that is actually displayed in the cell is at the end of the sentence rather than at the beginning.
I.e. If a user entered "London W1A 2BE - Go to Green Door" then "to Green Door" is what is displayed in the cell instead of "London W1A"
I have checked to properties of the textbox and the formatting of the actual cell and I just can't figure out why it is doing this.
could someone offer me any advice on how to resolve this please?
Many thanks
Paul