Is this possible with a Listbox control?

[Peter h]

I was just curious if it's at all possible to make column 1 (or actually 0) in a multicolumn listbox always visible as you scroll right. Similar to how freeze pane works on a spreadsheet. If not, that's ok. I'm just curious.

 

[ranman256]

dont think so. Its not that evolved.

 

[Fluff]

I agree with ranman256, but you might be able to do something with commandbuttons, which set the columnwidth.

 

[MickG]

What you could perhaps do is place another list box on the left of the original, just showing column 1.
Then using the code below will it should align the data as its selected.

Private Sub ListBox1_Click()
    With ListBox2
        .TopIndex = ListBox1.TopIndex
        .ListIndex = ListBox1.ListIndex
    End With
End Sub

Private Sub ListBox2_Click()
    With ListBox1
        .TopIndex = ListBox2.TopIndex
        .ListIndex = ListBox2.ListIndex
    End With
End Sub

 

[Yongle]

A workaround would be to use 2 listboxes, one with all required columns (A) , the other with column 0 only (B)
B is placed on top of A - so column 0 is always visible when scrolling occurs in A
Group them together

You only mentioned scrolling right. It gets more complicated if you also want to scroll up and down - the values in A & B must then move in sync.

Read MickG post - same idea as mine

 

[Peter h]

Thanks for the ideas guys. Its not so important that I want to go through a bunch of trouble for it, but I might play around with it to see what I can come up with.

 

[MickG]

You're welcome