Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Selections in a Combo Box???
Hi
I created a userform in which there r 3 combo boxes... the user can either choose to select the values in any of the combo boxes or don't do anything before he clicks on the command button to run the requested actions... For eg, the user chooses the country in combo box1, cus type in combo box2 and area in combo box3... n once the command button is clicked, a macro will actually run to filter the database according to the values of the 3 combo boxes... my question now is, is excel able to take in multiple selections in the combo boxes....? if yes how can i do it and how can i program the filter codes to take in these additional "requests" cos currently my knowledge only allows me to write code that will take only one value from each combo boxes... will appreciate any suggestions/advice... kindly advice me whether this is "doable" or not... cheers --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Selections in a Combo Box???
what is an "r 3 combo boxes"
if you mean comboboxes from the control toolbox toobar, then no, they do not have a multiselect property. Plus the concept of a multiple selection for a combobox is alien. Perhaps you mean listbox for which there is a multiselect property. cos currently my knowledge only allows me to write code that will take only one value from each combo boxes... Not sure what "cos" (cosine?) means, but it isn't a limitation of your knowledge. ActiveX Comboboxes and forms Dropdowns only have one value so I would suspect your "r 3 combo boxes" have the same limitation. Autofilter only can accept two conditions in each filter. So if you have two conditions, you would just set them. (recording a marco while doing it manually using custom shows you how). Advanced filter can accept more complex conditions. "Or" conditions are in columns, "And" are inconditions in rows. -- Regards, Tom Ogilvy "hce " wrote in message ... Hi I created a userform in which there r 3 combo boxes... the user can either choose to select the values in any of the combo boxes or don't do anything before he clicks on the command button to run the requested actions... For eg, the user chooses the country in combo box1, cus type in combo box2 and area in combo box3... n once the command button is clicked, a macro will actually run to filter the database according to the values of the 3 combo boxes... my question now is, is excel able to take in multiple selections in the combo boxes....? if yes how can i do it and how can i program the filter codes to take in these additional "requests" cos currently my knowledge only allows me to write code that will take only one value from each combo boxes... will appreciate any suggestions/advice... kindly advice me whether this is "doable" or not... cheers --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box Showing Date Selections | Excel Discussion (Misc queries) | |||
Counting Combo Drop Down Box Selections | Excel Worksheet Functions | |||
Multiple selections | Excel Discussion (Misc queries) | |||
Can List or Combo Box have multiple selections? | Excel Worksheet Functions | |||
List box with multiple selections | Excel Programming |