Get List Box Selection From VBA

[jo15765]

I am trying to get the selected item from a list box using VBA, I tried to use

Me.lstAddedManually1.value

but that does not work.

The list box is called lstAddedManually1 and has the options of

Blue
Red
Green
Pink

No indexes or addtional rows. How can I use VBA to capture the selected value from that listbox?

[pbaldy]

If the listbox is multiselect, you'll need VBA code. What you have should work if it isn't. The code looks like:

http://www.baldyweb.com/multiselect.htm

[jo15765]

If the listbox is multiselect, you'll need VBA code. What you have should work if it isn't. The code looks like:

http://www.baldyweb.com/multiselect.htm

Ah that was it, I was not taking into account the value being null!

[pbaldy]

Happy to help!