+ Reply to Thread
Results 1 to 3 of 3

Adding picture in userform

  1. #1
    Registered User
    Join Date
    09-10-2020
    Location
    worcester
    MS-Off Ver
    2016
    Posts
    43

    Adding picture in userform

    Hi Everyone
    I have a big big questions:
    I want if is possible (can see in my code attached)
    when add new item,
    to add a picture from computer directly in to userform.
    and store (with specific name) some how ..i dont know maybe in a spredsheet
    because when i chose that item from main page i want to display
    there the image
    for more details i attached the code
    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: Adding picture in userform

    You want to display picture while Adding product and also display it on main tab of userform when choose particular product, right?
    So at the moment of 'upload' new picture (for new product) path into file have to be save somewhere. Of course I suggest one of columns in row of product.

    Load picture into particular image control:
    Add new:
    Please Login or Register  to view this content.
    on Main
    Please Login or Register  to view this content.
    Check attached file. You can add picture (with preview on Add tab), when you click Add Inventory, path into this file will be save on Sheet1 (let say it is new product name) in cell A2.
    Then click on Main and choose Sheet1 in Search item, picture should appear in picture window.
    Attached Files Attached Files
    Last edited by KOKOSEK; 03-30-2021 at 10:55 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    09-10-2020
    Location
    worcester
    MS-Off Ver
    2016
    Posts
    43

    Re: Adding picture in userform

    thaks
    i will let you know
    thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Picture in VBA Userform
    By travelkid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-07-2019, 10:04 AM
  2. Need help with adding a picture using VBA
    By dustinsolomon_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2017, 12:14 PM
  3. Replies: 2
    Last Post: 05-24-2016, 05:27 AM
  4. [SOLVED] Using picture to display table from worksheet on userform; need help modifying picture
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2014, 10:34 AM
  5. UserForm With Picture
    By Herve_Rob in forum Excel General
    Replies: 6
    Last Post: 02-16-2007, 09:07 AM
  6. How to get a picture on a userform?
    By Alex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2006, 07:15 PM
  7. [SOLVED] RE: How to get a picture on a userform?
    By sebastienm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2006, 07:10 PM

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