hi, all
i have a problem about show dynamic rowsource data from sheet to listbox on userform it just show one col while i have four cols in my sheet
this is my code
hi, all
i have a problem about show dynamic rowsource data from sheet to listbox on userform it just show one col while i have four cols in my sheet
this is my code
You have set your ListBox's ColumnCount to zero so nothing will display.
Use the ListBox's List Property, not RowSource.
hi royuk i would asking about this line to understand it
what means -1 and resize about resize as far as i know move right to left or opposite from col to col or row to row if i'm not wrong but this i don't understand
That line removes the header row, I should have put a note in the code
thanks royUK for your code and the clearing
Pleased to help
Don’t have an account yet? Register yourself now and be a part of our community!