copy paste data from a userform textbox to worksheet

[jalmeida87]

Hello everyone !

I need some help please.
I canīt copy information from a textbox (userform) to a range in a worksheet because an error appears when the code try to past the information in range

The error is this : "run time error 1004 paste method of worksheet class failed"

The code of my vba macro is :

if textbox.value = "TABELA" then
textbox.Copy
Sheets("TARIFAS").Select
Cells(1, 1).Select
ActiveSheet.Paste --> The error appears here
Sheets("TARIFAS").Visible = False
Else
End If

CAN SOMEONE HELP ME please ?

Regards

[gmr4evr1]

Is your sheet named TARIFA, or TARIFAS?

[jalmeida87]

Sorry is TARIFAS..
However i fixed the name in my first comment.