With the release of Excel 2016 Microsoft has added 6 new functions to the lineup. To link a text box to a cell have the text box selected click in the Formula Bar and press and then click the cell to link to and press Enter see Figure 02. We know the format of the sentence to be framed.
While text box is selected put your cursor in the formula bar type in symbol and then click on the cell you want to link to and finally press the Enter key.
Because internally Excel stores dates as serial numbers and the formula would process those numbers not the dates displayed in cells. If you want to do exactly as you describe ie the very next keystroke is then you will need to re-activate the UserForm otherwise youll simply add an into your selected cell. Formula TextValue format_text Where. Click the Insert tab at the top of the window.