Checked list: is it possible in VBA?

[Redo]

Hi all,

I've just 3 short questions for you:

1 - Is it possible build a checked list box (or checked combobox) in VBA
Form?

2 - If it is possible, is it necessary to add a particular library reference
in Tools->references?

3 - If it is possible, could you post a short piece of code about that?


Thanks a lot!!

 

[Jan De Messemaeker]

Hi,

1. In the properties of a listbox, for List Style select 1 -
fmlistsyleoption

2. Not necessary, but you may miss some of the help for that API.

3. Both are manual settings, so which code?

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Mike Glen]

Hi Redo,

Try posting on the developer newsgroup as this one is closing down. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP



Hi all,

I've just 3 short questions for you:

1 - Is it possible build a checked list box (or checked combobox) in VBA
Form?

2 - If it is possible, is it necessary to add a particular library reference
in Tools->references?

3 - If it is possible, could you post a short piece of code about that?


Thanks a lot!!

 

[Redo]

"Jan De Messemaeker" <[email protected]> ha scritto nel messaggio

1. In the properties of a listbox, for List Style select 1 -
fmlistsyleoption
2. Not necessary, but you may miss some of the help for that API.

3. Both are manual settings, so which code?

Hope this helps,

Thank you for your reply.
The problem is I would like to enable a multiple choice by a drop down menu
with a list of checked boxes;
Something like that: http://www.danfernandez.com/view/view.aspx?ID=157
I found this link:
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_24060703.html
but, in my VBA editor, I can't find "Microsoft ListView Control 6.0" the
link above refer to....

 

[Jan De Messemaeker]

Hi,

You won't have iit as a drop down menu but as a form, it looks exactly as
you show.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf