Private Sub TextBox1_LostFocus()Dim sObjName as string, li as long,lNon as longsObjName = "TextBox"lNon = 1strDate = TextBox1.ValueFor li = 1 to 4if li <> lNon thenUserform1.Controls(sObjName & li) = strDateend ifNext liEnd Sub