Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
column headings for a list box from a recordset
This is probably (and hopefully) simple, but my eyes are seeing blurry from
all the time in the help screens and I still can't find the solution. I have a recordset . I have a multi-column list box with columnheads set to true. I have assigned values from the recordset to the list box as follows: lst.Column() = rs.GetRows How in VBA can I populate the column headings in the list box with the column names in the recordset (e.g., rs(0).Name) Thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
column headings for a list box from a recordset
You can't. Only if you bind the listbox to data in the worksheet - this
means using the rowsource/listfillrange property. -- Regards, Tom Ogilvy "in-over-his-head-bill" wrote: This is probably (and hopefully) simple, but my eyes are seeing blurry from all the time in the help screens and I still can't find the solution. I have a recordset . I have a multi-column list box with columnheads set to true. I have assigned values from the recordset to the list box as follows: lst.Column() = rs.GetRows How in VBA can I populate the column headings in the list box with the column names in the recordset (e.g., rs(0).Name) Thanks for any help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
column headings for a list box from a recordset
Thanks so much for the help. I will just throw some labels on top of the list
box with the recordset column names. "Tom Ogilvy" wrote: You can't. Only if you bind the listbox to data in the worksheet - this means using the rowsource/listfillrange property. -- Regards, Tom Ogilvy "in-over-his-head-bill" wrote: This is probably (and hopefully) simple, but my eyes are seeing blurry from all the time in the help screens and I still can't find the solution. I have a recordset . I have a multi-column list box with columnheads set to true. I have assigned values from the recordset to the list box as follows: lst.Column() = rs.GetRows How in VBA can I populate the column headings in the list box with the column names in the recordset (e.g., rs(0).Name) Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
How do I keep column headings from showing on a list? | Excel Worksheet Functions | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
List Box Column Headings | Excel Programming |