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