Listbox Capture From Other Closed Workbook Excell VBA Userform

[@riansutarsa660]

glad to you Mr. razakmcr and then how to I can edited by that userform to that data on closed workbook?

[@razakmcr]

Thanks for watching. Pls follow ruclips.net/video/JJgGFWm4z1k/видео.html

[@razakmcr]

ruclips.net/video/Eqi551gNCJ0/видео.html

[@jcbong811]

good day sir, how to make the Listbox capture only last 10 row lastest data from workbook?

[@razakmcr]

Thanks for watching request video soon thanks

[@safeerahmed4474]

Sir how many columns can I add using this VBA code to listbox

[@riansutarsa660]

Sir, please help when I try to run, an error appears '380' could not set the list property. invalid property value.
could it be because the column that I use there are 15 columns of "A: O" ??
please solve it sir!

[@razakmcr]

Thanks for watching. List box use column 10(0 to 9)

[@safeerahmed4474]

Can I add 45 colums

[@razakmcr]

Thanks for watching. Follow. ruclips.net/video/j4KZEy0Yw0Y/видео.html

[@safeerahmed4474]

Pls help