Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 04-23-2016, 11:44 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel ListBox Windows 7 64bit Excel ListBox Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps this will help http://www.contextures.com/xlDataVal02.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
filter, list, listbox

Thread Tools
Display Modes


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 06:25 AM.


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