Command button

[Guest]

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?

 

[Bob Phillips]

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)

 

[Guest]

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