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
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Setting language of a selected text in Office apps. 0
Menu driven PowerPoint presentations 0
Auto populate value from one task to another in MS PROJECT 0
Create a chart from a table in word thats dynamic 0
How do we put typical mathematical and equations symbols into Word Office Maths Editor? 0

Top