+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : How do I insert a picture in userform from the web?

  1. #1
    Registered User
    Join Date
    03-10-2012
    Location
    FL, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    How do I insert a picture in userform from the web?

    I need to insert a picture that appears on a webpage in userform. The picture I want to insert is :
    "http://chart.finance.yahoo.com/z?s=NFLX&t=1y&q=&l=&z=l&a=v&p=s&lang=en-US&region=US"
    I 'd like to get the codes and where I should place them.
    I tried to insert it in the following and I couldn't:
    Private Sub Image1_Click()
    Private Sub UserForm_Initialize()
    Private Sub TextBox1_AfterUpdate()
    Private Sub MultiPage1_Change()
    The only image I could insert was a file saved in my hard drive
    Any help will be greatly appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: How do I insert a picture in userform from the web?

    The easy way to do this is at design time.

    So there is an image on the web you want to use. First thing is to download the image to your PC(right click on the image and select save image as, or something like that). Remember where you put it.
    Next, you have the choice to put it directly into a userform object(control) or an image control object.
    In design time, access the properties window for either the userform or the image control. Select the "picture" property and then select the image file that you downloaded. There are some options for images in both types of controls. You may want to try them out.

    Remember this: Just because you can use someone else's image, does not mean you have the right to do so. There are copyright laws.

    Hope this helps.

  3. #3
    Registered User
    Join Date
    03-10-2012
    Location
    FL, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How do I insert a picture in userform from the web?

    I know that. What you just posted is exactly what I don't want to do. The image I need to import is a chart that changes every second. I need to insert the image directly from the webpage. Thank you for trying

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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