trying to populate a listbox with rows from sheet then when selected split into textbox

[justlearning123]

trying to get a user for so that when the userform opens it puts each used row up to column q from sheet3 in listbox1 then when a row in the listbox is selected it spits it into the different textboxes names textboxA to textboxq... any way this can be done? thank you

[LokeshKumar]

do you have the sample workbook?

[MickG]

Try this in you Userform Module.
NB:- The code assumes your TextBoxes are called "TextBox1, TextBox2--- TextBox17" etc.

Please Login or Register  to view this content.