+ Reply to Thread
Results 1 to 8 of 8

Show Vendor Details By Selecting Sub Items From VBA Drop Down List

  1. #1
    Forum Contributor
    Join Date
    04-18-2014
    Location
    Pune, India
    MS-Off Ver
    Excel 2021
    Posts
    119

    Show Vendor Details By Selecting Sub Items From VBA Drop Down List

    Hello to All Experts,

    I have created user form to get vendor details, product specification and picture.

    category and sub items working perfectly and i stuck below following points,

    1) i want to get vendor details and specification of the products by selecting sub item.
    2) also i want product picture.

    Please find the attached file.

    Thanks in advanceShow Product Vendor Details.xlsmproduct pic.xlsx

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Show Vendor Details By Selecting Sub Items From VBA Drop Down List

    Can we clarify the terminology. You mention selecting the sub item but you can't do that before choosing the Category which you don't mention.

    Do you mean that you to listed the Sub items for the Category you choose

    How are the Vendor details linked to sub items. i.e. if you choose 1121 Golden Sella what Vendor would you expect and why.

    What do you mean by wanting the product picture. I can see no picture images in the file.

    Have you considered using normal Data Validation Cells to obtain the information rather than a VBA userform?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    04-18-2014
    Location
    Pune, India
    MS-Off Ver
    Excel 2021
    Posts
    119

    Re: Show Vendor Details By Selecting Sub Items From VBA Drop Down List

    Hi Mr. Richard,

    first I'm really sorry for the late in reply and thanks for your quick reply.

    ya when i choose category dependent list will appear in sub item, i.e. if i select rice in category only rice sub item will appear and its working beautifully as i mentioned before.

    after selection sub item i want vendor details i.e. if i select 1121 golden sella only 1121 golden sella vendor i want in vendor detail list also specification of the sub items.

    i have uploaded a sub items picture file also.

    Thanks and regards

  4. #4
    Forum Contributor
    Join Date
    04-18-2014
    Location
    Pune, India
    MS-Off Ver
    Excel 2021
    Posts
    119

    Re: Show Vendor Details By Selecting Sub Items From VBA Drop Down List

    is anyone to help above the subject

  5. #5
    Forum Contributor
    Join Date
    04-18-2014
    Location
    Pune, India
    MS-Off Ver
    Excel 2021
    Posts
    119

    Re: Show Vendor Details By Selecting Sub Items From VBA Drop Down List

    i'm wondering why no one is here to help me out

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Show Vendor Details By Selecting Sub Items From VBA Drop Down List

    ..Maybe because you haven't yet answered my question on line 3 of post #2

  7. #7
    Forum Contributor
    Join Date
    04-18-2014
    Location
    Pune, India
    MS-Off Ver
    Excel 2021
    Posts
    119

    Re: Show Vendor Details By Selecting Sub Items From VBA Drop Down List

    Dear Richard,

    if i choose product from a category list sub items working perfectly. Now what i want to do is if i select sub items form the drop down box for example if i select 1121 golden sella i only want selected sub item vendor details in the list box.

    Attaching again vendor details file and Item picture for your reference.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    04-18-2014
    Location
    Pune, India
    MS-Off Ver
    Excel 2021
    Posts
    119

    Re: Show Vendor Details By Selecting Sub Items From VBA Drop Down List

    Hi Richard,

    Awaiting for your reply

+ 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. Display Vendor Details And Picture on Product Selection
    By MdYas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2015, 08:00 AM
  2. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  3. [SOLVED] Need data to show by selecting a category in a drop down list
    By uahmed90 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-21-2015, 01:30 AM
  4. Replies: 0
    Last Post: 04-22-2014, 11:03 PM
  5. Quickly Selecting Items in a Drop Down List
    By Squint in forum Excel General
    Replies: 2
    Last Post: 03-14-2014, 01:25 PM
  6. Creating a drop-down list & selecting multiple items
    By Jamie6521 in forum Excel General
    Replies: 1
    Last Post: 02-08-2009, 02:53 AM
  7. Selecting multiple items in a drop down list
    By ACM-GFT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2008, 01:59 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