I doubt it's faster with a loop but your code looks far better and is shorter that way and takes away writing time.
I never rename Objects for coding purposes.
@ Deep
Something like this writes 10 textbox values to 10 rows in worksheet.
![]()
for i = 1 to 10 cells(i,1) = me("textbox" & i).text next
Bookmarks