For doing the same write this code in your form intialize event (or anywhere
else you wish)
Text1.Text = Sheets("Sheet1").Cells(1, 1).Text
and vice versa you may modify this value and put it back to excel sheet
using..
Sheets("Sheet1").Cells(1, 1).Value = Text1.Text