Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding multiple combo boxes to excel cells
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple combo boxes | Excel Discussion (Misc queries) | |||
Problem Adding new Combo Boxes | Excel Discussion (Misc queries) | |||
Adding to auto-filter combo boxes | Excel Programming | |||
multiple combo boxes | Excel Discussion (Misc queries) | |||
Adding the same content to multiple combo boxes | Excel Programming |