+ Reply to Thread
Results 1 to 6 of 6

Autocompletion and Icons

  1. #1
    Registered User
    Join Date
    01-14-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    9

    Autocompletion and Icons

    Hey, I want autocompletion and icons in my excel document. Eg. I type [hdd1] and the text gets replaced with an custom png or gif file of 24x24 size or so, in this case an icon of an HDD with number 1 in the lower right.
    I do not need the icons, only need ot know if having such a function in a ducument would be possible and if someone wouldnt mind writing or explaining how to write it.
    Thank you

  2. #2
    Registered User
    Join Date
    01-14-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Autocompletion and Icons

    Supposebly impossible

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Autocompletion and Icons

    You can use event code behind the spreadsheet to cell changed cell content and insert image if required.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    01-14-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    9

    Talking Re: Autocompletion and Icons

    Quote Originally Posted by Andy Pope View Post
    You can use event code behind the spreadsheet to cell changed cell content and insert image if required.

    Please Login or Register  to view this content.
    Sweet thanks, I'll try it out.
    Is "case" possible in this code? To easier list more items. Or could I use a dynamic file-value so that it uses the entered text as file-name?
    Ex. c:\temp\HDD1.gif would be used if [HDD1] was entered, and for all text entered within [] or maybe img[value]
    I'm guessing I can figgure out how to use case in this senario, not sure if I can wrap my mind around the image location values, unless fixed for each case.
    Thanks again,
    Bb

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Autocompletion and Icons

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-14-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Autocompletion and Icons

    Ah, can not put multiple icons in a row it seems, unless they all have their own cells. Or can excel detect where the picture is and move it in case cell width or such change? I fixed height and width to 12 so it would fit in a row.
    Maybe I should try and make some PHP document that does this stuff instead ;p Probably easier even though I do not know much php, thanks for all help.

    I guess it will work with one cell, since can make it react to adding x in a cells and such instead.

+ 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