Hi John,

There are a couple of ways of doing this. One is to set the TextBox property
Linkedcell to a cell somewhere in the workbook and enter the value in that
cell.

Another way is to use the got focus event to set the value when the user
clicks in the textbox.

Private Sub TextWeek_GotFocus()
Me.TextWeek = 20
End Sub

--
Regards,

OssieMac