Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Linked Combo's and List box

Posted on 2014-03-06
1
Medium Priority
?
195 Views
Last Modified: 2014-03-07
Hi,
The other day, Kevin (zorvek) helped me to get unique values into a combobox as well as sorting and formatting it.
I then copied the code and played around with it, to try and populate a second combobox with unique values from data in the next column where the first combo box gets it's data, but I keep hitting a brick wall.

Basically, I am looking to end up with this;
combobox1 is filled with unique values from sheet "ShiptToy" column G.
I am trying to get combobox2 to also get unique values from sheet "ShiptToy" column F, based on combobox1's selection.
Then I would like ListBox1 to be filled with data from sheet "ShiptToy" columns B and D based on combobox2's selection.

I don't know whether it's possible, and it may be a bit too much to ask.
I have attached a trimmed-down version of the original workbook, and if I can get this sorted, I could then try and adapt any help to fit other procedures on other sheets.

As always, any help is much appreciated.
ComboLinx.xlsm
0
Comment
Question by:Stephen Byrom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
Stephen Byrom earned 0 total points
ID: 39912864
I'll do it with a table in the sheet.
Seams the easiest
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question