VBA - Textbox as caption

[becklog]

Hi,

I have a userform with several textboxes and a submit button.
My goal is to show a summary box of all entered data when the submit button is clicked.


Below is the code that I have but is not working. Thanks for the help!


Private Sub CommandButton1_Click()
Summary.Show
End Sub


then

---summary form---


Private Sub userform_initialize()
LawsonCon2.Caption = Lawsonbox.Value
End Sub

 

[DanteAmor]

Try:

Private Sub userform_initialize()
   LawsonCon2.[B][COLOR=#800080]Caption [/COLOR][/B]= [B][COLOR=#0000ff]Userform1[/COLOR][/B].Lawsonbox.Value 'change Userform1 by the name of your userform that contains the textbox
End Sub

LawsonCon2 is a textbox or a label?

If it is a label then it is correct to use .Caption, if it is a textbox then you must use .Value

If you do not want the editable textbox then:

Private Sub userform_initialize()
    LawsonCon2.Enabled = False
    'or
    LawsonCon2.Locked = True
    '
    LawsonCon2.Value = UserForm1.Lawsonbox.Value 
End Sub

 

[becklog]

Oh my, now I remember

Thanks a lot!

 

[DanteAmor]

You're welcome