How to bring data from a listbox to a cell?

G

gatarossi

Dear all,

I have a listbox in a form, and I need to bring the selected itens in
a cell... How can I do it?

For example:

lstTest

Item 1 (Selected)
Item 2 (Not Selected)
Item 3 (Selected)

So when I click in a button in this form, the cell (1,1) needs to have
the data: Item 1, Item3

I input this code in the button, but it brings only the first item in
the lstTest...

Cells(1, 1).Value = lstTest.List

Thanks in advance!!!

André.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bring all data from a lstbox to a cell 1
Bring all data from a cell to a listbox inside a form 1
Set Cell value form ListBox. 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
A way to increase a number in a cell by using the + key 2
Bring Data From MS Acess in a Combobox 1
Sum.product with text conditionals 4
Adding Macro to each item in Combo Box 0

Top