Results 1 to 8 of 8

Product Comparison

Threaded View

  1. #1
    Registered User
    Join Date
    08-14-2017
    Location
    MX
    MS-Off Ver
    2011 Mac Excel Ver 14.6.6
    Posts
    18

    Product Comparison

    Greetings everyone,

    Hope someone can guide me a little with a project I'm working on, the objective is to be able to compare the same product from 3 different companies. I have all the information in Excel.

    I'm using MAC MS Excel ver 14.6.6.

    I'm building a MS Excel User Form like this:
    Captura de pantalla 2017-08-14 a la(s) 1.57.01 AM.png
    Note: There is a price tag and box for each company missing, I have added that. Also a small box were the image would show.

    Were the user can select the characteristics from a drop down menu and when they click Search, information will appear, showing the results from each company.

    And my Excel worksheet looks something like this, I made a smaller example to keep it simple but I have over 3000 products for each company:
    Captura de pantalla 2017-08-14 a la(s) 2.12.51 AM.png

    Few considerations I would like to include:
    - If there is 2 or more matching results for 1 company, that the user form shows an arrow indicating there is another product matching the search and when they click it, show the second, third, etc result.
    - I have an image pasted as a comment on each product, is there a way to show the image in the user form? I also have all the images in a folder named by the product code, the thing is I want to share this file to others.

    I'm not experienced with Visual Basics, I can understand the code and edit simple stuff. I'm very thankful for any help I can get.

    Regards,
    Last edited by DanPa; 08-14-2017 at 03:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Replacement product finder - Searching for matches based on various product attributes
    By gingert88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2017, 01:17 PM
  2. Replies: 8
    Last Post: 10-14-2015, 11:58 AM
  3. Replies: 9
    Last Post: 10-16-2014, 07:46 AM
  4. [SOLVED] I'm receiving a Run-Time error 1004 while trying to delete a product from a product list.
    By redsab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2014, 10:03 PM
  5. Product comparison
    By kolonel in forum Excel General
    Replies: 2
    Last Post: 01-08-2013, 12:25 AM
  6. [SOLVED] Find Product Details in Another Sheet based on Product ID and Copy some Fields From there
    By kevalkothari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 10:43 AM
  7. [SOLVED] Need Function that will find ordered product, and display the product code in a 2nd workbk
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 08:52 AM

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