Runt-time error '424': Object required

[anthonymedz]

Hi guys,

Good day.
Can someone help me to solve the error.
When i run the program the error always occurring.

I program it using ActiveX control but then when i copy the program to transfer to Form control(Macro) it suddenly occurred an error.

Code:

UserForm1.Show

'Duty Engineer
Sheets("Completed").Select
Range("B54").Select = TextBox1.Text -> error starts here
Range("B55").Select = TextBox2.Text


'Lead Tech
Sheets("Completed").Select
Range("B58").Select = TextBox3.Text
Range("B59").Select = TextBox4.Text


'Technician
Sheets("Completed").Select
Range("B62").Select = TextBox5.Text
Range("B63").Select = TextBox6.Text
Range("B64").Select = TextBox7.Text
Range("B65").Select = TextBox8.Text


UserForm1.Hide

End Sub

 

[igold]

Try this:

[COLOR=#333333]Range("B54").Value = TextBox1.Text[/COLOR]