I've created an XL spreadsheet with COMBO BOXs with INDEX/MATCH formulas.
However I want to edit it further, in brief to arrange COMBO BOX A to Z, with no repetition, and only with relevant information based on previous combo box selections. Presumably this may involve VB code.
FILE hyperlink below is spreadsheet of COMBO BOXs http://www.1sar.karoo.net/exoftable0.xls file size 111kb's
To go into greater detail about the spreadsheet and desired results, it is a simple DATABASE of CARS, with a RESULTS PAGE, much like an excel version of AUTOTRADER, a basic example without photos & descriptions.
The Combo Boxs are:
COLUMN A: CAR MAKE
COLUMN B: CAR MODEL
COLUMN C: CAR TYPE
COLUMN D: CAR COLOUR
The criteria of Combo Box's in 'ComboBox CHOICE & RESULTS', sorts results from source 'WORKSHEET'.
My spreadsheet looks ok, however the combo box's I've made lack the functionality I need, and to edit them further I'm unfamiliar with, hence they need editing to:
i) Arrange COMBO BOXs to display in Alphabetical order, A to Z of available fields
ii) or even better, arrange COMBO BOX A to Z, with no repetition
iii) Combo Box's following from Previous, left to right, only to display relevant fields possible based on previous selections, not all fields in that column listed in COMBO BOX, PROPERTIES, ListFillRange, some examples below:
Example 1:
COLUMN A: If PEUGEOT is selected, then in
COLUMN B: The only choices would be 206 or 207 or 306 or 307
etc
or
Example 2:
COLUMN A: If PEUGEOT is selected, then in
COLUMN B: If 206 is selected, then in
COLUMN C: only HDi would be available, then in
COLUMN D: The only choices would be SILVER or BLUE
Perhaps there are better, also easier to use spreadsheets, obviously the WORKSHEET spreadsheet is very good, and the autofilter is fast & effective at the same tasks described here, however I want a COMBO BOX spreadsheet without seeing the total full list of entries in the WORKSHEET. Also DataAccesspages are html, I want an XL file.
However I haven't seen/found or worked with such an example so far. My intention is that copies for other purposes can easily changed, by changing the titles, and then results worksheet sort is left unchanged hence will only display fields to choose from.
Hence if you have such a spreadsheet, care to share as attachment/hyperlink?
I have a FORMULA only version of this WORKBOOK but as per this post I want a COMBO BOX version, to see such a FORMULA derived RESULTS, see spreadsheet 'RESULTS206' as an example: http://www.1sar.karoo.net/exoftable6.xls file size 451kb's
CROSSTHREAD: http://www.mrexcel.com/forum/excel-q...ml#post3327597
Bookmarks