ExcelBanter - Listbox column headings

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

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

- - Listbox column headings (https://www.excelbanter.com/excel-programming/318888-listbox-column-headings.html)

BT[_3_]

Listbox column headings

Is there a method of writing to the listbox headers after making the
property true?

Tom Ogilvy

Listbox column headings

No - use of listbox headers requires that the control be databound. Then
the headers are obtained from the row above the range defined for
Rowsource/Listfillrange.

--
Regards,
Tom Ogilvy

"BT" wrote in message
...
Is there a method of writing to the listbox headers after making the
property true?

Adrian

Listbox column headings

Surely there must be a sneaky workaround to this using API's / hidden names
or something - isn't there an example on ozgrid?

Just a thought!

Cheers

"Tom Ogilvy" wrote:

No - use of listbox headers requires that the control be databound. Then
the headers are obtained from the row above the range defined for
Rowsource/Listfillrange.

--
Regards,
Tom Ogilvy

"BT" wrote in message
...
Is there a method of writing to the listbox headers after making the
property true?

Tom Ogilvy

Listbox column headings

If OZgrid has an original solution, post it.

--
Regards,
Tom Ogilvy

"Adrian" wrote in message
...
Surely there must be a sneaky workaround to this using API's / hidden
names
or something - isn't there an example on ozgrid?

Just a thought!

Cheers

"Tom Ogilvy" wrote:

No - use of listbox headers requires that the control be databound.
Then
the headers are obtained from the row above the range defined for
Rowsource/Listfillrange.

--
Regards,
Tom Ogilvy

"BT" wrote in message
...
Is there a method of writing to the listbox headers after making the
property true?

All times are GMT +1. The time now is 04:02 AM.