+ Reply to Thread
Results 1 to 7 of 7

Inputting pictures into UserForm

  1. #1
    Registered User
    Join Date
    05-06-2009
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    4

    Inputting pictures into UserForm

    Hi all

    I discovered this sample database sheet (attached) on the forum I wanted to ask if a picture can be linked included? i.e. when entering a new record a picture (stored in a directory) can be added and linked to that record. Then when reviewing the records the picture is then displayed.

    Can anyone help as my VBA skills are limited.
    Attached Files Attached Files
    Last edited by DCHill; 05-11-2009 at 06:07 AM. Reason: Request to change title

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

    Re: Inputting pictures into UserForm

    You should be able to load a picture when a name is selected, I'll look at an example later
    Hope that helps.

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

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    05-06-2009
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    4

    Smile Re: Inputting pictures into UserForm

    RoyUK

    Did you find that example?

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

    Re: Inputting pictures into UserForm

    I haven't had time yet, probably be the weekend before I have enough time to combine the two examples

  5. #5
    Registered User
    Join Date
    05-06-2009
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    4

    Smile Re: Inputting pictures into UserForm

    RoyUK

    As and when you have time but in advance many thanks.

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

    Re: Inputting pictures into UserForm

    I have added this feature to the sample form, the images need to be stored in a sub folder called images in the same folder that the workbook is in. Some sample pictures are included in the zip file.

    I have also updated some of the existing code

    http://www.excel-it.com/vba_examples.htm

  7. #7
    Registered User
    Join Date
    05-06-2009
    Location
    hollywood
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Inputting pictures into UserForm

    Excellent - Many thanks Roy

+ 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