We already learnt about the text box in excel. [ click here for information about text box in excel ].
Normally text and numbers are inserted in the cells simply as we insert text in a word processor. Text box behaves as a separate entity which can be modified separately. There are many different situations which come across when we are working with text box and cells together.
In this article we’ll look into the case when we want to link a text box and cell. It means , the text in the text box will depend upon the text in the cell.
WE CAN LINK A TEXT BOX TO ANY CELL WHICH WILL MAKE THE TEXT BOX SHOW THE VALUES PUT IN A CELL, WHICH CAN BE RESULT OF ANY CALCULATION OR OUTPUT FROM ANY LOOKUP.
A sample is given below.
The picture above is a text box created in an excel sheet and applied various text options which can be opted only in the text box and not on the text or values given in the cells.
2. If we have a graphical representation and we have a dynamic output which is based on some calculation. In that case we need to link the output to the text box.
In addition to these, there can be other requirements also.
Let us take an example of a simple sum.
The inputs are given in two cells but the output will be shown in the textbox.
LINKING TO A TEXT BOX DOESN’T MEAN THAT TEXT BOX WILL BE THE OUTPUT CELL. BUT IT’LL JUST ACT AS A FANCY TEXT WHICH WILL SIMPLY SHOW THE TEXT OF A CELL.
Suppose we have two cells containing any text and the result will be displayed in a text box.
The situation is as shown in the picture below.
In the picture above, we can see that there are two numbers, FIRST NUMBER and SECOND NUMBER and their sum is shown in the result as the FIELD NAME RESULT.
We want to show the result of the sum in a text box as in the following picture.
Let us first try to create a text label as shown in the picture below.
Let us check the output for the linked text box.
We have changed the first number and second number to different values and we can see that the text box value is changing as the expression changes.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE