Recall cell value in Excel into textbox.

This may seem basic but I'm stuck!

I have an applet with a textbox and a button called update.
When you type in the textbox and click update, it puts the value typed in the textbox in nominated cell in Excel.
When I recall the applet the textbox is empty and when you click update it obviously clears the cell.

What I want to happen is for the textbox to show the value in the cell when i recall the applet.

Post some code. What do you mean by applet?

Sorry I thought It was a bit unclear.

I have a window with two text boxes (firstname_1) & (Surname_1) and a button 'update'.
This window is opened from Excel via a button. That part is easy.
When the window is shown you insert the frist and last name in the text boxes and click update. The button is as below..

Private Sub UPDATE_Button_Click()
Sheets("Summary").Activate

Range("r8").Select
ActiveCell = FirstName_1.Text
Range("s8").Select
ActiveCell = Surname_1.Text
end sub


Easy..

Then when i want to edit the text and open the window.. the boxes are empty. I do not know how to have the boxes show the cell values upon opening.
I am currently using a button comand next to update, shown below..

Private Sub GetNames1_Click()

FirstName_1.Value = Range("R8").Value
Surname_1.Value = Range("s8").Value
end sub

How do I make to window recall the information upon opening.

Dale

add the code of GetNames1 to the Form_Load thingy or call GetNames1_Click from where you open the window.