Question

Excel vba textbox怎麼取行数？

假如有六行就执行一个sup六次

Answer 1

textbox1.text=application.counta(range("a:a"))
range("a:a")就是你表格的某列，

Answer 2

for n=1 to 6

Me.Controls("textbox" & n)=cells(n,1)
next