Command button
 

I have a userform(1) with 12 textboxes, in each textbox there is a name.
Userform2 there are 12 commandbuttons which will open userform to amend
details.
Is there a way that the commandbuttons reflect what is written in each
textbox?
--
AOU

Command button
 

Private Sub Userform_Activate()

With Me
.CommandButton1.Caption = Userform1.TextBox1.Text
'etc
End With

this presumes that you haven't unloaded the first form.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"AOU" wrote in message
...
I have a userform(1) with 12 textboxes, in each textbox there is a name.
Userform2 there are 12 commandbuttons which will open userform to amend
details.
Is there a way that the commandbuttons reflect what is written in each
textbox?
--
AOU

Command button
 

Bob,
Fantastic.........you must have a huge brain!
It works a treat....many thanks
--
AOU


"Bob Phillips" wrote:

Private Sub Userform_Activate()

With Me
.CommandButton1.Caption = Userform1.TextBox1.Text
'etc
End With

this presumes that you haven't unloaded the first form.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"AOU" wrote in message
...
I have a userform(1) with 12 textboxes, in each textbox there is a name.
Userform2 there are 12 commandbuttons which will open userform to amend
details.
Is there a way that the commandbuttons reflect what is written in each
textbox?
--
AOU