Vacuum Sealed was thinking very hard :
On 19/05/2012 2:50 AM, Neel wrote:
I have a list that I created through Data Validation. However, in the
list offered, people should be able to choose multiple responses. Is
there way to include checkboxes in my data validation list? Or, better
yet, is there a smarter, easier way to do this?
Thanks in advance,
Neel.
Neel
DV can't be used in this fashion, it is more like a Combobox, so to speak.
I think what you are after is a Listbox which can be created using Xl2010 -
Developer | Insert | Form Controls
As for coding it, I can't help you with that part as it goes beyond my level
of experience and I'm not 100% sure if it is Multi-Select capable although
one of the other many guru contributors many help shed some more light on it
for you.
HTH
Mick.
Mick,
Both ComboBox and ListBox controls can bet set to MultiSelect, and can
display checkboxes. The issue I see here is how will the OP handle the
selections?
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion