Does this help https://www.thespreadsheetguru.com/l...rform-control/

Also, if textboxes are named with sequential suffix, like tbxD1, tbxD2, etc, can probably just loop those controls - this works in Access VBA.

For x = 1 to 6
   MsgBox = UserForm1.Controls("tbxD" & x).Value
Next