+ Reply to Thread
Results 1 to 3 of 3

Insert picture into userform from hyperlink on worksheet

  1. #1
    Registered User
    Join Date
    09-10-2009
    Location
    Brighton,England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Insert picture into userform from hyperlink on worksheet

    Hi, can somebody help me please?

    I have a simple form which is used as a vehicle enquiry screen.

    When the user presses commandbutton one, it finds the vehicle number entered in textbox1 from sheet1 on the active worksheet and displays details about that vehicle.

    Column D of the worksheet holds a list of hyperlinks which display a picture of the vehicle.

    The form collects data such as registration, vehicle type etc.

    I would like to be able to display the hyperlink from col D as a picture on the form automatically.

    Is this possible?



    Any help appreciated

  2. #2
    Registered User
    Join Date
    09-10-2009
    Location
    Brighton,England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Re: Insert picture into userform from hyperlink on worksheet

    OK, I have managed to get the hyperlink stored in a variable called Pic.

    How do I cahnge the properties of Image1 to that of the hyperlink value in order to display the picture?

    Any help appreciated.

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

    Re: Insert picture into userform from hyperlink on worksheet

    Hard to say without seeing the hyperlink or any code.
    But have a look at the LoadPicture method. You need to provide the folder/filename from the hyperlink as the argument.
    Cheers
    Andy
    www.andypope.info

+ 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