Closed Thread
Results 1 to 19 of 19

Is there a way when type image name in textbox it load out that image?

  1. #1
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10

    Is there a way when type image name in textbox it load out that image?

    Hi all,
    First time using excel. Firstly i want to know is there a way to load an image out when u type the image name in the textfield.
    Example when I type in my name it load my image out beside the name.
    If it is not possible please tell me... and I would appreciate if there is a tutorial on this.

    Thank you in advance...

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hello,

    Welcome to the forum, may be this link will help?

    http://exceltips.vitalnews.com/Pages..._a_Result.html
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10
    thx for the reply... nice tutorial but if i have 1000 pics i need repeat the steps 1000 times? LOL

  4. #4
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10

    HOW to display picture based on cell value

    Hi i know nth abt excel... But my boss ask me to do this:

    Step1: Type the picture name that is store somewhere in the computer (C:/MyDocument/Pics)
    Step2: After typing the pic name into the cell, the pic that is the same name as the cell text will be display (Type "apple" and the other cell load out the apple pic that is stored)

    Can any excel master teach me? I 1st time using excel... Need urgent help
    Thanks

  5. #5
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10

    HOW to load Image Based on cell value???

    Hi i know nth abt excel... But my boss ask me to do this:

    Step1: Type the picture name that is store somewhere in the computer (C:/MyDocument/Pics)
    Step2: After typing the pic name into the cell, the pic that is the same name as the cell text will be display (Type "apple" and the other cell load out the apple pic that is stored)

    Can any excel master teach me? I 1st time using excel... Need urgent help
    Thanks

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Show,

    Are you saying if cell A1 had the path "C:\My Documents\Pic\Apple.jpg", and I typed "Apple" into cell B1, the picture would be displayed? If so, where in another cell? Will the picture be removed from the worksheet if the cell doesn't equal apple?

    Thabks,
    Leith Ross

  7. #7
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10
    Is it possible to have cell A1 to contain the path of all image? Then in cell B1 IF i type 'apple' the apple.jpg pic display in cell A1 ELSEIF type pear display pear.jpg pic in A1 ELSE not found display 'no match' in A1...

    Any idea? I 1st time user of excel only not sure if i explain correct anot... Any example or codes to reference? Thank for reply

  8. #8
    Registered User
    Join Date
    10-08-2007
    Posts
    1

    Please visit my web

    Please visit my web:
    www.addin-for-excel.blogspot.com

  9. #9
    Registered User
    Join Date
    07-02-2006
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    23
    Hi show...

    Try the atachment...

    Hope it helps

    Marcos.
    Attached Files Attached Files

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    yudhy,

    Very interesting web site. What language is it in?

  11. #11
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10
    socram, that look real cool... but i not sure of the code...
    Q: can u explain the codes? put some comments in the vba script?
    Last edited by show; 10-10-2007 at 03:00 AM.

  12. #12
    Registered User
    Join Date
    07-02-2006
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    23
    Quote Originally Posted by show
    socram, that look real cool... but i not sure of the code...
    Q: can u explain the codes? put some comments in the vba script?
    sure... (sorry for that)

    take a look now !!!

    I think this time that's okay...

    Marcos.
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10
    Lol this look more cool... It locked with password

  14. #14
    Registered User
    Join Date
    07-02-2006
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    23
    Ooooo....

    Sorry again, show...

    password= infomav

    Marcos.

  15. #15
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10
    I dunno how to open the other code file that specific the image path folder one... lol<---found it zzz
    Also asking if it is possible to enter the image name in any cell without deleting the pic previously enter?
    Q:Example:
    Type 'apple' in A1 apple.jpg display THEN type 'pear' in A2 pear.jpg display and apple.jpg nv disappear THEN type 'cherry' in B4 cherry.jpg display but apple.jpg and pear.jpg nv disappear, you understand?
    Type in any cell pic display and not in any specific cell only... Is it possible? And also without refreshing the pic position after i have centralize it Thanks
    Last edited by show; 10-10-2007 at 10:01 PM.

  16. #16
    Registered User
    Join Date
    07-02-2006
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    23
    Just comment (') the line shown bellow...

    Please Login or Register  to view this content.
    otherwise, you can enter several images at the same time, and then arrange as you want !!!
    Example: image1,image2,image3............image50,image85... and so on

    But ask, is you need !!!

    Marcos

  17. #17
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10

    Thumbs up

    YEAH, socram you are just COOL!!, GREAT!! AND FANTASTIC... this is what i wanted... cos I may enter 100 over pic image, there4 this works the way...


    Thank for the great help u gif and the time u spent on me

  18. #18
    Registered User
    Join Date
    07-02-2006
    Location
    Brazil
    MS-Off Ver
    2013
    Posts
    23

    Thumbs up

    show...

    glad to help you !!!!

    you are always welcome !!!!

    Marcos.

  19. #19
    Registered User
    Join Date
    10-09-2007
    Location
    Singapore
    Posts
    10

    Lightbulb

    sorry again,
    Just wanting to know if the cell value that enter apple is being delete would it be possible to check for IF cell A1 ='apple' deleted THEN apple.jpg also deleted? LOL

Closed 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