Listbox with zero entries

[shankar]

I want to have a listbox in a Windows form which needs to have a header row. But it should allow the option of having zero entries. However this is not possible, since I have to specify at least one row for RowSource to display the header (the row above the first row of the range).

So how is it possible to have zero entries in the list? Right now I am setting the first row of RowSource as a blank and Enabled property to false if there are zero entries to be displayed. But I am wondering if there is a better way. Thanks.

Shankar

[mdmackillop]

This uses a dynamic range name as the row source. Counting the Header to form the range size provides the range which allows the header to be displayed.

[drawworkhome]

mdmackillop;
cool feature.
erik

[shankar]

Thanks, but there is a blank row that is selectable in your example. Is there a way to make no row selectable, other than by disabling the control?

[mdmackillop]

I wouldn't think so. What is the problem with doing that?

[drawworkhome]

is there a way manually place text in the columnhead via code (vba)?

[mdmackillop]

I don't believe so, other than by changing it in the rowsource.

[drawworkhome]

thats what i think also. i tried like heck last night and couldnt find/discover a way to do it.

erik

[mdmackillop]

Why not add a textbox immediately above the Listbox?

[drawworkhome]

that is what i currently have. i am a newbie, so am learning all i can.
erik