Populate userform with values from another sheet.

[ipbr21054]

I’m asking now as I have an early start tomorrow so hoping to save me some time in waiting for a helpful reply.
Thanks.


I have a userform which will have multiple text boxes.

These Textboxes will be populated from values in cells on another sheet.

I’m not sure how to write it but if you can advise I can then follow & complete this in the morning.

I am working on a sheet called MCINFO & this is where the form will be opened from.

The info needs to be taken from a sheet called MCVIN

So textbox1 should be populated with info from sheet MCVIN in cell F5

I can then follow the advice given to complete the others.

 

[hungtbatman1]

If I understand your intention, the code in the UserForm1 module

Private Sub UserForm_Initialize()
    TextBox1.Value = Worksheets("MCVIN").Range("F5").Value
End Sub

 

[ipbr21054]

Thanks now completed