H
hce
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
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