So, here I am just going to say about how you can easily add dynamic Value of any cell in your Shape objects.
Step1: Draw a shape in excel.
Step2: Select shape, and click on Formula Bar.
Step3: Write Cell address in formula bar...
You are done!!!
Tuesday, July 13, 2010
Add Dynamic Value in Excel Shape Object
On Many forums and discussion page I have found people talk about adding value in shape object with VBA code. But I always try to avoid VBA unless and until, can't find solution with Excel inbuilt features....
So, here I am just going to say about how you can easily add dynamic Value of any cell in your Shape objects.
Step1: Draw a shape in excel.
Step2: Select shape, and click on Formula Bar.
Step3: Write Cell address in formula bar...
You are done!!!
So, here I am just going to say about how you can easily add dynamic Value of any cell in your Shape objects.
Step1: Draw a shape in excel.
Step2: Select shape, and click on Formula Bar.
Step3: Write Cell address in formula bar...
You are done!!!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.