Command button

A

AOU

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?
 
B

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)
 
Top