Filter

[peter_martin]

Good mornig,
I'm new to these kind of help forums
Can you helpe me for the syntax error in vbafiltre v1 -EN.xlsm

[SamT]

Have you tried Debug Menu >> Compile VBA Project? It will find many problems

When you get an error when running the form. click Debug instead of Help.

[peter_martin]

yes i know but i can not solve the problem iam beginner plz some one can you helpe me

[SamT]

Yes you know...

We are having a language problem.

Have you Compiled the project yet?

[peter_martin]

Im sorry i am a french speaking
for my project is not compiled i wait your help SamT

[SamT]

In order to metteur au point your code, the VBA Menu has the item "Debug". and the sub Item "Compile VBAProject," (Compilez le projet VBA)


Debug-Compile Menu.png


When VBA Compiles your code, it informs you of any obvious errors when it finds one. Then it stops. You must fix the error and Compile again to find the next Error.The first time that I compiled your code, it stopped at

Private Sub OptionButton9_Click()
    m = "VERIF"
    Call CommandButton11_Click
End Sub

With the error message "Sub or Function Not Defined." This tells that you have not made that code yet.

But. I did make that code and when I Compiled again, I had the same error.

Assume that the CommandButton code is

CommandButton11_Click
MsgBox "metteur au point your code"
End Sub

You should write another Sub

Sub ShowMessage1 ()
MsgBox "metteur au point your code"
End Sub

And point both CommandButton11_Click and OptionButton9_Click to the new sub

Private Sub OptionButton9_Click()
ShowMessage1
End Sub

Private Sub CommandButton11_Click
ShowMessage1
End Sub

When I am writing Code, I Compile many times whenever I think that I have some bit of code that should compile OK.

All Translation done with MyMemory - translation

[peter_martin]

Thank you SamT