Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-23-2016, 05:32 PM
koreggan koreggan is offline Excel ListBox Windows 7 64bit Excel ListBox Office 2016
Novice
Excel ListBox
 
Join Date: Apr 2016
Posts: 1
koreggan is on a distinguished road
Question Excel ListBox

Hello there,

I'm working in a project where I need to use two list boxes to fill a form with selected data. It goes something like this:

I have a db with Company, Product and the product's specifications. So, for example, I have:



Company 1 - Product 1 - Specifications 1
Company 1 - Product 2 - Specifications 2
...
Company 2 - Product 1 - Specifications 1

And it goes on like this.

What I need is to create a list box containing the companies and a second list box containing the products. The real magic is, when I select the company in the first list box the second one is filtered to only products of the selected company and only then I select the product that I want and it fills the form.

Can someone help me with this task?

Cheers.
Reply With Quote
 

Tags
filter, list, listbox



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel ListBox DropDown ListBox does not Drop Down mmaule Word VBA 1 08-02-2015 05:40 PM
This is a Userform LIstbox queston: A variable does not set to the value of a listbox CatMan Excel Programming 14 08-18-2014 08:14 PM
Excel ListBox This is a Userform LIstbox queston: A variable does not set to the value of a listbox CatMan Excel 1 08-08-2014 09:41 AM
Data from Excel to Listbox multiselect to Word marksm33 Word VBA 2 02-18-2014 08:30 AM
Excel ListBox Multi-select listbox help gvibe@hotmail.com Word VBA 1 07-19-2013 10:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft