Adding multiple comboboxes using VBA

[KevinC2000]

Hello all,

I have created the attached matrix to help me priorities data collection of different datasets for a project I am working on.

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

[pike]

Mab in the validation list box source value
remove the $s and drag cells
=$A$2:$A$3
Becomes =a2:a3