FILE hyperlinks below are spreadsheets of COMBO BOXs, both of these need editing:
i) http://www.1sar.karoo.net/exoftable0a.xlshttp://"http://www.1sar.karoo.net/exoftable0a.xls" file size 119kb's MACRO version A, needs A-Z sort, needs relevant TYPE for MODELS of same MAKE
ii) http://www.1sar.karoo.net/exoftable0ab.xlshttp://"http://www.1sar.karoo.net/exoftable0ab.xls" file size 120kb's MACRO version B, needs editing for relevant only. Blanks from COLUMN C cause inconsistency. And ROWS with same MAKE of different MODELS display TYPES of all that MAKE.
Spreadsheet i) Is a macro A version, possibly, this just needs the properties of VB combo boxs editing for A-Z relevant, as well as error documented below. Currently in this version the only edit to the combo boxs, is edited from VB CODE/MACRO, PROPERTIES, in LinkedCell & ListFillRange.
Spreadsheet ii) is a macro B version, it makes a simple error:
For CAR MAKE (Column A) with numerous MODELS (Column B),
then TYPE (Column C) displays all possible TYPES for that CAR MAKE (Column A).
Eg: Vauxhall there are 2 entries:
i) Vauxhall, Astra, VXR
ii) Vauxhall, Nova, SRi
When searching
MAKE: VAUXHALL
MODEL: ASTRA
Then wrongly TYPE displays:
SRI
VXR
INTRODUCTION TO PURPOSE OF SPREADSHEET:
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 '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.
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.
The spreadsheet original for the 1st combobox is
iii) http://www.1sar.karoo.net/exoftable.xls</a></strong>http://"http://www.1sar.karoo.net/exoftable0ab.xls" file size 111kb's non-MACRO version. 1st version.
The above spreadsheet was derived from my FORMULA RESULTS spreadsheet below:
iv) http://www.1sar.karoo.net/exof…ong></a><strong></strong>http://"http://www.1sar.karoo.net/exoftable0ab.xls" file size 451kb's non-MACRO version
CROSSTHREADS:
http://www.mrexcel.com/forum/e…relevant.html#post3327597
http://www.excelforum.com/exce…s-of-words.html?p=3026357