Now let’s take a look at a few applications of Text Boxes Application 1 : Create Dynamic Comments There are 2 things that you must remember about dynamic text boxes Step 3 : Link the text box to the cell value Step 2 : Create a Text box and write anything into it Step 1 : Insert a Data Validation Drop Down The applications of this technique in Dashboards, Charts and Visualizations is pretty helpful
in simple terms the text can change as per the situation I am sure you would have worked with the text boxes in Word or PowerPoint or even Excel but the trick I am going to share with you will make the text boxes dynamic.