Multi-Column Listboxes correspond to multi textboxes
I am Stumped...
I have set up a userform that contains a listbox with 6 columns. Above that I have 6 textboxs that I would like to correspond to the Listbox.
So when I select a row on the listbox, the cells of that row populate the textboxes.
Is this possible??
Thank you for your Time!!
-Kyle
Hi Crebsington
what have you tired?
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
Hi Kyle
Try this codeOption Explicit Private Sub ListBox1_Click() With ListBox1 TextBox1.Text = .List(.ListIndex, 0) TextBox2.Text = .List(.ListIndex, 1) TextBox3.Text = .List(.ListIndex, 2) TextBox4.Text = .List(.ListIndex, 3) TextBox5.Text = .List(.ListIndex, 4) TextBox6.Text = .List(.ListIndex, 5) End With End Sub
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks