Linking a Drawing Object to a Cell
Here’s how you can link a cell’s value to be displayed inside a drawing object. In this example, a Text Box is being used, but this method will also work for Rectangles and other draw-able Forms shapes.
In Excel version 2003, find the Text Box icon on the Drawing toolbar by clicking View > Toolbars > Drawing to show that toolbar, then click onto the Text Box icon as shown.
![DrawingToolbar_TextBox_Version2003](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_v7gKZjYAORAYSgzA3ed__Oz2RDj8tM384B-d7xBFGrS7_F8poY_P7-MDaAS5AlVmzki88fuIArSDTU3X-FBpj089QxRkuczHsWG4f1NDHkl3mPDPXU5Heiy2xHYh5BQImGdVNSuHZiWl6tQnz7VIKXj2Cym8AWmXdWYWEQ=s0-d)
For Excel versions 2007 or after, click onto the Insert tab, click the Shapes button, and click onto the Text Box icon as shown.
![Shapes_Version2010](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sIKVlkAe4936FqTpGyCkJwMlV-UHRnABuDgJp3O8yE7NAL8h-jTY9ogt2Nby8aN5OGpNnKHMfwtc7Nqd6e6lobLBl6XAQisA1GgVTDHpLvG67d7fcWOm_BS9zmAcrSzKBj5DZUF1qyhumxxg=s0-d)
As you see in the following pictures, draw the shape onto your worksheet, and select it. In the formula bar, enter a formula such as
=A1
, or whichever cell whose value you want the shape to show.Whether the linked cell (A1 in this example) is meant for manual data entry, or it holds a formula, the shape will also show that cell’s contents.
#evba #etipfree #kingexcel📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
No comments:
Post a Comment