B
Barry Wainwright
I am struggling with this.
I have a workbook that carries out calculations based on user's input data.
Part of these calculation involve lookups from static data sets that the
user selects from a combobox look up form object
Worksheet 1 has a combobox that allows the user to look up materials in
column 1 of a list in worksheet 2 (which is hidden). Various material
characteristics are returned for that material from columns 2 thru 8 of the
list in sheet 2. These values are used in various calculations.
This is all working fine, except that the list of material in sheet 2 is
growing too quickly - I am now up to about 40 materials, which makes
selecting the right one in the combo box in sheet 1 too hard.
I want to group the materials into classes, and add a new combo box into
sheet 1 such that the user can first select the class of material (e.g.
Metals, plastics, woods etc); then, depending on which 'type' option the
user selects, the second combo box will use a different sheet (each with
it's own list) for the input main material selection.
Clear? As Mud?
OK:
sheet 1 - does the work and holds the combo boxes described above
Sheet 2 - holds a list of different types of wood
Sheet 3 - holds a list of different types of metal
Sheet 4 - holds a list of different types of plastic
Now, when the user selects the first combo box on sheet 1, he gets presented
with a list of 'Wood, Plastic, Metal, ... Etc. Let's say they select 'Metal'
They then select the second combo box and are presented with a list of
Aluminium, Brass, Steel, ... Etc
Anyone have any idea how to achieve this? It needs the input range for combo
box 2 to be dynamically assigned, and I can't figure it out
I have a workbook that carries out calculations based on user's input data.
Part of these calculation involve lookups from static data sets that the
user selects from a combobox look up form object
Worksheet 1 has a combobox that allows the user to look up materials in
column 1 of a list in worksheet 2 (which is hidden). Various material
characteristics are returned for that material from columns 2 thru 8 of the
list in sheet 2. These values are used in various calculations.
This is all working fine, except that the list of material in sheet 2 is
growing too quickly - I am now up to about 40 materials, which makes
selecting the right one in the combo box in sheet 1 too hard.
I want to group the materials into classes, and add a new combo box into
sheet 1 such that the user can first select the class of material (e.g.
Metals, plastics, woods etc); then, depending on which 'type' option the
user selects, the second combo box will use a different sheet (each with
it's own list) for the input main material selection.
Clear? As Mud?
OK:
sheet 1 - does the work and holds the combo boxes described above
Sheet 2 - holds a list of different types of wood
Sheet 3 - holds a list of different types of metal
Sheet 4 - holds a list of different types of plastic
Now, when the user selects the first combo box on sheet 1, he gets presented
with a list of 'Wood, Plastic, Metal, ... Etc. Let's say they select 'Metal'
They then select the second combo box and are presented with a list of
Aluminium, Brass, Steel, ... Etc
Anyone have any idea how to achieve this? It needs the input range for combo
box 2 to be dynamically assigned, and I can't figure it out