Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calling a Logo from an Equation (2002)

    Would anybody know how to have a logo appear based upon a Y/N response to a formula in cell. I have a logo in a picture located in another part of a worksheet. I would like to be able to make it appear and disappear at a specific location. I tried an if statement, thinking I could name the picture as a range -- but I have not been able to get it to work.
    Any Ideas?

    Second question -- Does anyone know how to size a dropdown list box to be seen when the sheet size is made smaller. There seems to be a one to one relation between the list font size and the sheet % size.
    Any ideas?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Calling a Logo from an Equation (2002)

    1) Check out my file in <post#=291936>post 291936</post#>. I think this will do what you want. Post back with any specific questions.

    2) Instead of using the dropdown from the FORMS toolbar, use the dropdown from CONTROL TOOLBOX toolbar. This has options to control the size. The only way to adjust the size of the FORMS one is to set the zoom to get the size of the text in the combobox to what you want, then decrease the FONT size of the REST of the workbook and then change the column and row sizes to match.

    The combobox in the control toolbox, allows colors, formatting, fontsize and can also run code based on many different events (the FORMS allows only triggering off the one event). The DISADVANTAGE of the control toolbox combobox, is that is a little less "user friendly" and it can not be added to a chart sheet.

    Steve

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calling a Logo from an Equation (2002)

    That is what I want to do, however when I look at your example I see how the number changes the good/bad col but I'm not seeing how/where the picture reference evaluates the col.
    I know I'm missing something simple ???

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Calling a Logo from an Equation (2002)

    There are several named ranges:
    B1 is named "Good" and the cell contains a PICTURE of a smiley face
    B2 is named "Bad" and the cell contains a PICTURE of a sad face

    Cells E1:E11 have the formula like:
    =(IF(G1>0,"good","bad"))

    So based on g1:G11, cells E1:E11 will have the contents "good" or "bad"

    Over the cell F1 is a LINKED picture. It is linked to the name "A"
    Over the cell F2 is a LINKED picture. It is linked to the name "B"
    Over the cell F3 is a LINKED picture. It is linked to the name "C_" ("C" is not an allowed name)
    and so on till F11
    The NAME of "A" refers to: =INDIRECT(Sheet1!$E$1)
    The NAME of "B" refers to: =INDIRECT(Sheet1!$E$2)
    The NAME of "C_" refers to: =INDIRECT(Sheet1!$E$3)
    etc

    So NAME A has an (indirect) link to the NAMED range that is LISTED in cell E1

    So if G1 has the value of 4
    then E1 will evaluate to "good"
    and the name A will reference the RANGE named good which is Cell B1 and thus a picture of cell B1 will be displayed.
    B1 has a picture of a smiley face in it.

    So if G1 has the value of -1
    then E1 will evaluate to "bad"
    and the name A will reference the RANGE named bad which is Cell B2 and thus a picture of cell B2 will be displayed.
    B2 has a picture of a sad face in it

    Every picture you want to be variable MUST refer to a named item!

    Steve

  5. #5
    New Lounger
    Join Date
    Jul 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calling a Logo from an Equation (2002)

    Thanks Steve, that helped me over the hump.

Posting Permissions

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