In the userform, below is the column name and the object name to be saved in the column. How can I save the "Personnel" and "Member" pages at the same time by giving the row number to column A starting from row 2 with Commandbutton? Thank you, I present my respects.
A = Sequence Number
B = Me.TextBox1.Value
C = Me.TextBox2.Value
D = Me.ComboBox2.Value
E = Me.ComboBox3.Value
F = Me.ComboBox4.Value
G = Me.TextBox3.Value
H = Me.TextBox4.Value
I = Me.TextBox5.Value
J = Me.TextBox6.Value
K = Me.TextBox7.Value
L = Me.ComboBox5.Value
M = Me.ComboBox6.Value
N = Me.TextBox9.Value
O = Me.TextBox10.Value
P = Me.TextBox11.Value
A = Sequence Number
B = Me.TextBox1.Value
C = Me.TextBox2.Value
D = Me.ComboBox2.Value
E = Me.ComboBox3.Value
F = Me.ComboBox4.Value
G = Me.TextBox3.Value
H = Me.TextBox4.Value
I = Me.TextBox5.Value
J = Me.TextBox6.Value
K = Me.TextBox7.Value
L = Me.ComboBox5.Value
M = Me.ComboBox6.Value
N = Me.TextBox9.Value
O = Me.TextBox10.Value
P = Me.TextBox11.Value