Userform Label automatically displays information from several textboxes

[dylanrose]

Hi to all,

Userform

I would like to ask if there is a possible way for a Label to display information that are based on multiple textboxes?
All the information are based on the textboxes and listboxes that are in the userform and will be displayed on the Label (label16)

 

[Gavin T]

Label to display information that are based on multiple textboxes?...

I'm not sure what you mean by based on multiple textboxes. However, if you want to concatenate the two textboxes you can try the following:

Label16 = TextBox1 & TextBox2

Or if you want to populate the label on condition then try this:

If TextBox1 = "Test" And TextBox2 = "Test2" Then
    Label16 = "We are testing"
End If

 

[dylanrose]

I'm not sure what you mean by based on multiple textboxes. However, if you want to concatenate the two textboxes you can try the following:

Label16 = TextBox1 & TextBox2

Or if you want to populate the label on condition then try this:

If TextBox1 = "Test" And TextBox2 = "Test2" Then
    Label16 = "We are testing"
End If

Hi Gavin T.
Thanks for answering my question.

Should I put the code in a change event? or where should I put the code?
Also, Yes, I would like to concatenate the textboxes but separated by a comma. How should I code it?
I tried using:

Label16.Caption = TextBox1.Text & ", " & TextBox2.Text

But to no avail, it gives me error. Is there a possible workaround for this?
Thanks Gavin T!

 

[Gavin T]

Should I put the code in a change event? or where should I put the code?...

When would you like the label to update? You could put it in both of the textboxes change events as follows:

Private Sub TextBox1_Change()
    Label16.Caption = TextBox1.Text & ", " & TextBox2.Text
End Sub

Private Sub TextBox2_Change()
    Label16.Caption = TextBox1.Text & ", " & TextBox2.Text
End Sub

Your code to concatenate is fine. Make sure you're putting the code in the forms private module. You can get there by hitting F7 when your in the form design view.

Good Luck!

 

[dylanrose]

When would you like the label to update? You could put it in both of the textboxes change events as follows:

Private Sub TextBox1_Change()
    Label16.Caption = TextBox1.Text & ", " & TextBox2.Text
End Sub

Private Sub TextBox2_Change()
    Label16.Caption = TextBox1.Text & ", " & TextBox2.Text
End Sub

Your code to concatenate is fine. Make sure you're putting the code in the forms private module. You can get there by hitting F7 when your in the form design view.

Good Luck!

Gavin T,
I want it to automatically update as I click my comboboxes, listboxes and type in in textboxes. Is there a way that I can send you my excel workbook so that you could see what I have so far? I can't seem to attach my file here.

Thanks so much Gavin T!

 

[Gavin T]

You can upload your workbook here https://www.box.com/ and paste a link to it back here. Although, I can't guarantee a response.

 

[dylanrose]

You can upload your workbook here https://www.box.com/ and paste a link to it back here. Although, I can't guarantee a response.

It's okay if just some workaround in the file and just take your time. I'll try different methods too.

Here's the link of my excel workbook: https://app.box.com/s/4chonojq5mjjc3dysh28

Thanks Gavin!

 

[AlphaFrog]

deleted