ExcelBanter - Populate cells with Listbox items

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Populate cells with Listbox items (https://www.excelbanter.com/excel-programming/385408-populate-cells-listbox-items.html)

microsoft[_7_]

Populate cells with Listbox items

How can i do this:

Range("B8:D8).vaue = listbox2.listindex = 0

IE.
The forst listed item in the Litbox to be placed into the cell.
B8:D8 are merged cells

Corey....

[email protected]

Populate cells with Listbox items

Hi
Range("B8:D8).vaue = listbox2.List(0)
regards
Paul

On Mar 16, 10:01 am, "microsoft" wrote:
How can i do this:

Range("B8:D8).vaue = listbox2.listindex = 0

IE.
The forst listed item in the Litbox to be placed into the cell.
B8:D8 are merged cells

Corey....

All times are GMT +1. The time now is 09:50 AM.