Thread
:
Drop Down List - Select Multiple Items
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
Drop Down List - Select Multiple Items
I am not familiar with what you describe.
Note: I do not do much programming so my knowledge is limited.
Perhaps someone will recognize the process from your description?
Maybe a userform or similar?
Gord
On Mon, 9 Jun 2008 02:40:45 -0700 (PDT),
wrote:
I've got the same problem and while searching on the Internet to find
out anyway to get a drop-down list with check-box element inside, I
found this article but it is still not exactly what I would like to
have..
I've already seen somebody using a speadsheet with a multichoice drop-
down list, it looks like a autofilter fucntion and allow you to select
more than one criteria for your filtration. when you click on the
arrow on right side of the cell, it show you a drop-down list with all
the check-boxes in side the list, then you can select whatever item by
click on approriate checkbox. And at the bottom of the dropdown list,
there is 2 buttons, OK and Cancel, if you select OK, then the
Filtration process will start with all the criteria you've selected in
checkboxes inside that drop-down list.
I really want to know how to get this done, even by VBA macro but I
could not find anything like this on the internet. I really
appreciated if you can help me to point out where is the right
direction to find any solutions for this problem.
Thank you very much and look forward to your feedback soon..
Best regards,
Hao.
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben