Probably a bit of a longshot this, is there a anyway i can display the results of a formula within my workbook in a clipart image? I know we can add text or use it as a macro button but i cant find anything that says we can do this.![]()
Probably a bit of a longshot this, is there a anyway i can display the results of a formula within my workbook in a clipart image? I know we can add text or use it as a macro button but i cant find anything that says we can do this.![]()
Last edited by JimmiOO; 03-04-2010 at 04:42 AM.
You can't do this directly, but you could use a text box overlaid atop the clipart and set the text box to reference a cell.
See attached. The text box references C1. Change A1 or B1 to see changes in the clipart/textbox. The text box is set to not use a fill color or lines, so it appears transparent.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Ah that is pretty clever, thanks for that Palmetto
Glad to be of help.
Please be sure to mark your thread as solved bu going to top of YOUR first post and selection Thread Tools, then Go Advanced.
Feed back is always appreciated. See my signature for how to go about it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks