+ Reply to Thread
Results 1 to 4 of 4

List Formula Results Within ClipArt

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-07-2008
    Location
    sCOTLAND
    MS-Off Ver
    Office 2003 SP3
    Posts
    256

    List Formula Results Within ClipArt

    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.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: List Formula Results Within ClipArt

    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.
    Attached Files Attached Files
    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.

  3. #3
    Forum Contributor
    Join Date
    07-07-2008
    Location
    sCOTLAND
    MS-Off Ver
    Office 2003 SP3
    Posts
    256

    Re: List Formula Results Within ClipArt

    Ah that is pretty clever, thanks for that Palmetto

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: List Formula Results Within ClipArt

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1