Help?????Compiler errors

[thanhwru]

Dear all,

i have a trouble in scripts VB in excel. this issue is as follow:

Untitled.png

who can help me and tell me how to resolve this?

thank in advance with your help.

best regards,

Thanh

[shg]

Welcome to the forum.

You have provided no context to suggest an answer. I'd guess you have a form control named Value1 or Value2 -- but I don't even know if you have a form.

[thanhwru]

Dear shg,

yes, when i click in one form control, an error is as follow: Run-time error '40036' - Application-defined or object-defined error. And then i click to Debug, and control to that form.
for example:

Private Sub CommandButton3_Click()
Sheets("CALCULATE").Select
End Sub

Another thing, when i click directly that sheet (not form control), an error appears as i said


hope to receive your feedbacks to me as soon as.
thanks a lot