listbox display vertically and not horizontally

I have a listbox (listbox1) that is populating based on a combobox (cboSRegions) selection on a userform (frmOutreach). My data range is from A3:M with row 3 being column headings. cboSREgions search criteria is located in column B. My problem is I can get the listbox to display all the corresponding fields (13 columns of data) but it only displays it vertically in one column and not 13 columns of data horizontally. Here is my code that I am using:

Please Login or Register  to view this content.

Can you tell me what I am doing wrong? I also tried application.transpose but that didn't work. What I want is to display all 13 columns in one row based on combobox criteria. In other words, I want to display the entire row of data based on the criteria selected in the combobox. Also, if this is done, will the listbox be able to display all 13 columns using additem? If not, can you suggest a better way? Thank you in advance for any and all assistance.

Thanks for you quick response Norie. I am very new to VBA. Is it possible for you to provide a snippet of code that I can modify regarding arrays or the range process that you are referencing. I am not familiar with that approach. Do you have any additional guidance to offer?

Thank you Norie for your guidance and code snippet. It worked perfectly with just a minor modification. Thanks again ever soooo much.