cell updated with listbox selections

[dnelson24]

I have a form (Form1) with a listbox on it (ListBox1). The listbox gets it rowsource from Groups(a defined name range with the worksheet). I have the listbox set to SelectMulti. All I want is when I select 2 or more items, and click Button1, for the values selected to be placed in a cell (D45) and have each value separated by a comma. Since I know very litte about VB this is probably a simple question for someone!

Thanks so much in advance.

David

 

[petermeachem]

'placed in a cell'
Do you mean copied to an excel spreadsheet? If so, that isn't a trivial problem by any means.

http://www.accuflight.co.uk

http://www.lettersdirect.co.uk

http://www.trelliscoaching.com

http://www.fengshuimarketingcenter.com

http://www.ourhouseinportugal.co.uk