Enter value in textbox userform from a closed sheet on my pc

[ipbr21054]

Hi.
I have a userform with various textboxes.
I wish to populate each of these textboxes from sheets that are closed & on my pc.

Please advise how i write this correctly so the value is shown in the textbox in question.

TextBox1 should show the value from this files path

C:\Users\Ian\Desktop\EBAY\ACCOUNTS\PREVIOUS ACCOUNTS\2010 - 2011

Excel sheet is called SUMMARY 2010 - 2011.xlsl

The value is in cell E63


Once advise i can the follow / edit it for the other TextBoxes
Many Thanks

 

[Skyybot]

That only populates 4 Textboxes ?

Do you have any TextBoxes inside of a Frame?

 

[ipbr21054]

NO