Listbox in User form, selecting a column only of a row.

Dear friends,

I have added a listbox in my user form, which is a multi-column one. I would like to select an item of the list box, not the entire row when I click a column / row of the listbox. Is it possible to change to style of listbox to select an item and not the entire row of items?

Regards,
Pravin Kumar.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Dear torachan,

I hope that the post is clear enough. As you suggested, I can add a workbook generating a user form with a multi-column listbox, which on selection, selects the entire row of the list items. I am not sure how that will help. What I want is selecting a column of the list item row, where the mouse has clicked.

I am sure that somewhere some listbox settings I am missing. I thought that some experts can suggest that.

Regards,
Pravin Kumar.

The reason behind asking for an actual file enables us to work within your actual case.
Excel is very broad and there are numerous methods to achieve the same end.
it is counter productive to suggest a method that conflicts with the rest of your code.
My personal preference is to work with tables and arrays to populate combos/listboxes.
Rowsource is a method I rarely use due to its instability when used with large amounts of data transference.
A simple example file is attached, you will see in the code the transfer of each element of the listbox choice to individual textboxes.

Private Sub lbo1_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If Me.lbo1.ListIndex = -1 Then Exit Sub
If Me.lbo1.ListIndex > -1 Then sc = Me.lbo1.ListIndex + 2
ClearForm
Set ws1 = Sheet1
Set tbl1 = ws1.ListObjects("Table1")
With tbl1
For i = 1 To 6
Controls("txtbox" & i).Value = .Range(sc, i)
Next i
End With
End Sub

Thanks Torachan for your detailed reply. Though my post remains unanswered, your reply helped to clear some grey areas of my understanding.

Special thanks for the example file you had posted. My question was not about populating a multi-column listbox but selecting an item of the listbox (not a complete row but the row and column where the user clicks).

Attachment 700959

In the example file you had posted, I want to select only the date value when I click the sixth column of any row. Is it possible? Can we style the listbox while designing to have this ability?

Regards,
Pravin Kumar.

your attachment is shown as invalid - the paperclip does not work - follow the big yellow banners instructions.
you cannot directly select the individual column in the listbox.
the row is selected and by code you will have to seperate the elements of the row.
this is what is happening in the example by using the listbox.listindex to reference back to the cells populating the listbox

OK. I understand.
Thanks.