K
KevinC
Hello all,
I have created a matrix to help me priorities data collection of
different datasets for a project I am working on.
I have the same datasets listed horizontally and vertically so I have
the same number of rows and columns. Within each cell the user the
selects one of the two datasets in the matrix - choosing the dataset
which takes priority.
At the moment the user needs to type in values to complete the form,
what I would like do is have a combo box/drop down box in each white
cell so that there are only two options that the user can select from.
So for example in cell D3 the user could only select Schools or
Churches.
Is there a way that this can be easily in VBA? I have tried to work my
way round this using the Data Validation tool however it will not let
me enter two cells in two different locations.
I have thought that it might be possibleto count back from the active
cell to work out the values that need be added to combo box (using
AddItem?) but can't quite get my head round to how this can be done.
I also looked at the solution herehttp://www.contextures.com/xlDataVal14.html)
however I don't think I can use this as it uses the validation option
(requiring a range) where as I need to enter two list values instead.
Any help that can be given would be appreciated.
Regards,
Kevin
I have created a matrix to help me priorities data collection of
different datasets for a project I am working on.
I have the same datasets listed horizontally and vertically so I have
the same number of rows and columns. Within each cell the user the
selects one of the two datasets in the matrix - choosing the dataset
which takes priority.
At the moment the user needs to type in values to complete the form,
what I would like do is have a combo box/drop down box in each white
cell so that there are only two options that the user can select from.
So for example in cell D3 the user could only select Schools or
Churches.
Is there a way that this can be easily in VBA? I have tried to work my
way round this using the Data Validation tool however it will not let
me enter two cells in two different locations.
I have thought that it might be possibleto count back from the active
cell to work out the values that need be added to combo box (using
AddItem?) but can't quite get my head round to how this can be done.
I also looked at the solution herehttp://www.contextures.com/xlDataVal14.html)
however I don't think I can use this as it uses the validation option
(requiring a range) where as I need to enter two list values instead.
Any help that can be given would be appreciated.
Regards,
Kevin