G
goddard
I have a problem involving references from a combo box.
I created a combo box from the forms toolbar, right clicked, selected
format control(tab "control").
In the "Input range" I can select a range and an array shows up:
eg.
Sheet2!$A$2:$C$25
In the whole scope of things, I want to be able to designate the row
numbers in this array depending on a selection made by the user.
For instance on sheet 1 The user selects a county, sheet 2 has a list
of soil types and other columns per county. Row 1-46 would correspond
to one county, 47-55 another, etc.
I have set up an index of first and last row of values that can be
selected when the county is selected by the user
1,county1,1,46
2,county2,47,55
I then use VLOOKUP to lookup the start row and place it in, let's say
cell "D7" and the last row in the index will be placed in cell "E7"
The point of the combo box is to list the soil_types, etc. found in the
county that they have selected.
so the array in the input range would change depending on the county
selected.
This brings me back to my problem.
Is there a way to make this work in the input range:
Sheet2!$A$D7:$C$E7
"D7" would hold the start row and,depending on the county, change
"E7" would hold the end row and, depending on the county, change
I have tried many combonations of syntax,
can this be done?
Any suggestions would be helpful
I created a combo box from the forms toolbar, right clicked, selected
format control(tab "control").
In the "Input range" I can select a range and an array shows up:
eg.
Sheet2!$A$2:$C$25
In the whole scope of things, I want to be able to designate the row
numbers in this array depending on a selection made by the user.
For instance on sheet 1 The user selects a county, sheet 2 has a list
of soil types and other columns per county. Row 1-46 would correspond
to one county, 47-55 another, etc.
I have set up an index of first and last row of values that can be
selected when the county is selected by the user
1,county1,1,46
2,county2,47,55
I then use VLOOKUP to lookup the start row and place it in, let's say
cell "D7" and the last row in the index will be placed in cell "E7"
The point of the combo box is to list the soil_types, etc. found in the
county that they have selected.
so the array in the input range would change depending on the county
selected.
This brings me back to my problem.
Is there a way to make this work in the input range:
Sheet2!$A$D7:$C$E7
"D7" would hold the start row and,depending on the county, change
"E7" would hold the end row and, depending on the county, change
I have tried many combonations of syntax,
can this be done?
Any suggestions would be helpful