Populate userform from row values based on combobox

hi,

how can I build a userform to display all values from a row? in order to select a row, i was thinking to use a combobox to display values from one column and based on that selection, display all values in that row? the reason i want to use a userform is because i would also like to be able to edit that data. Any help would be much appreciated!!!!

thanks.

So you have a UserForm, lets call it UserForm1, and in it you have a combobox, lets call it combobox1, which will display all values from a column, in our case we will assume column A. You want to select a value in combobox1 and have it display all the values in that row in a listbox, lets call it listbox1. All of this will be occuring based upon the values in a worksheet which we will call "Sheet1". Here is code:

Please Login or Register  to view this content.

Thank you so much!

If I wanted to have each value displayed on a texbox, how would I have to do it?