Textbox name using variable

See more:

VBA

Hi,

I am creating a program using VBA (Excel). I have a userform and a couple of frames on it and each frame contain a couple of textboxes. Say,

frame 1 contain textboxes as follows,

tbxA1Name
tbxA1DOB
tbxA1Location

and frame 2

tbxA2Name
tbxA2DOB
tbxA2Location

and frame 3

tbxA3Name
tbxA3DOB
tbxA3Location

When I hit a button I want to fill excel sheet with the values of these textboxes using a few lines of codes.

I know to get the values and fill the sheet using normal coding but that's going to be a lot of lines.

Here only a digit changed as per the frame.

for frame 1 it's
A1
for frame 2 it's
A2
for frame 3 it's
A3


Can somebody help me?

Thanks in advance.

EDIT:

When I tried normal coding there was a lot of lines and it gave an error that Procedure too large.