ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List boxes (https://www.excelbanter.com/excel-programming/300771-list-boxes.html)

DENISE

List boxes
 
How do I add data to a listbox in two columns

with just one column it'd be
listbox1.additem "Joe Bloggs"

but I want the joe and the bloggs to be in two adjacent
colums.

TIA

Bob Phillips[_6_]

List boxes
 

Listbox1.additem "Joe "
Listbox1.List(Listbox1.Listindex-1,1)="Bloggs"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Denise" wrote in message
...
How do I add data to a listbox in two columns

with just one column it'd be
listbox1.additem "Joe Bloggs"

but I want the joe and the bloggs to be in two adjacent
colums.

TIA





All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com