Redundant Data entry

[EXCESSPOTENTIAL]

I have a work sheet were I enter a Job Number. That job number is used in several other cells and a text box.

1. I want to use the job number paired with the static prefix text TP- and user input to create the cell value.

Job number: 123456

User input: 064

Cell value: TP-123456-064

2. Can Text box contain formula values?

 

[Smitty]

Welcome to the Board!

You can concatenate the values like this:

="TP-"&A2&"-"&B2

Where Job Number is in A2, and User Input in B2.

To put that into a text box, draw one from the Developer tab, then set its Linked Cell property equal to the cell with the concatenated information.

HTH,

 

[EXCESSPOTENTIAL]

Ok I want to try and take it a step further. can it be hard coded into the same cell where the user input is so that the user is just typing the input

 

[EXCESSPOTENTIAL]

can the code be hard coded into the same cell as the user input?