exporting data from excel to display on userform

Question

I have a userform where I want to display data from a spreadsheet. The spread sheet is an input interface and the calculations will be displayed on my useform. My problem is to fetch the data. I have tried the code below, but what hapeens is that te correct data only appears if the user clicks on the label from the form. I need it to automatically load when i load the form. Where am I going wrong?

Private Sub Label3_Click()

Label3.Caption = Sheets("mysource").Range("o3")

End Sub

score 1 · Accepted Answer · 2017-11-21 16:52:05Z

1

Try using:

Private Sub UserForm_Initialize()

    Label3.Caption = Sheets("mysource").Range("O3").Value

End Sub

edited Nov 21, 2017 at 16:52

answered Nov 21, 2017 at 16:43

user8753746

Sign up to request clarification or add additional context in comments.

3 Comments

Luiza Over a year ago

Doesnt work. My problem is the "on click" command. I mean, when the form is loaded, it will show the data correctly IF i click on the label itself. Thats not what i want. I need it to open already showing the correct information.

user8753746 Over a year ago

Edited my answer. You should add that line in your UserForm Initialize event. Modify the name with your UserForm Name.

Luiza Over a year ago

Thanks!! That's exactly it.

Collectives™ on Stack Overflow

exporting data from excel to display on userform

1 Answer 1

3 Comments

Your Answer

Post as a guest

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Post as a guest

Related