+ Reply to Thread
Results 1 to 7 of 7

UserForm;Listbox Select Show Picture

  1. #1
    Registered User
    Join Date
    02-28-2009
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    12

    UserForm;Listbox Select Show Picture

    i have download sample worksheet( listbox picture.xls)
    i want copy the code to my book but there is some problem
    and i dont know how to make it right
    please someone take a look my book and help me to fix it
    anyway thank you very much
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by samsara; 03-06-2009 at 02:42 AM. Reason: post again not in zip file

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

    Re: UserForm;Listbox Select Show Picture

    Hello smasara,

    Whatprogram did you use to Zip the files? My program (WinZip) says the files are not in standard Zip format.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-28-2009
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: UserForm;Listbox Select Show Picture

    i am use winzip pro V 1.2.0

    now i post the xls files
    thanks Ross for replay
    Last edited by samsara; 03-06-2009 at 02:35 AM.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: UserForm;Listbox Select Show Picture

    What problem are you getting.
    There is no code currently in the form to paste a picture to the image control.

    Ross, the zips open OK with AlZip -
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    02-28-2009
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: UserForm;Listbox Select Show Picture

    Ok thanks for replay ,
    the file ( list_box_picture.xls :Bart simpson.jpg:Abraham Linclon.jpg;nopic.gif ) is a sample file
    you can extract to your desktop and open the listbox picture.xls and see how is work
    and my book.xls is my app so i want like that (like listbox picture.xls)
    when i select the listbox from my userform the picture will be show up too
    i have try to copy the code from userform (listbox picture.xls) to my book .xls but still have problem maybe have a mistake i dont know
    so i delete the code from my userform
    please Roy take a look for a moment

    the listbox picture.xls used "myName" ("A2:A200")
    in my book.xls i want use range "D2 : D200 " to be myrange

    am sorry Roy my english poor
    hope u can understand me
    thanks again ...

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

    Re: UserForm;Listbox Select Show Picture

    http://www.vbaexpress.com/forum/showthread.php?t=25500


    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    02-28-2009
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: UserForm;Listbox Select Show Picture

    yes i have cross post with the other site
    if what am do is wrong
    i want to say sorry to Admin and all moderator in this forum
    i'm confess for my false
    and i'm apoligize for my careless
    thank for warning me

+ 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