PDA

View Full Version : Filter



peter_martin
01-11-2016, 06:09 PM
Good mornig,
I'm new to these kind of help forums
Can you helpe me for the syntax error in vba15142

SamT
01-11-2016, 06:22 PM
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
01-11-2016, 06:31 PM
yes i know but i can not solve the problem iam beginner plz some one can you helpe me

SamT
01-12-2016, 11:51 AM
Yes you know...

We are having a language problem.

Have you Compiled the project yet?

peter_martin
01-12-2016, 02:46 PM
Im sorry i am a french speaking
for my project is not compiled i wait your help SamT :(

SamT
01-12-2016, 04:25 PM
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)


15153


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 SubWith 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 SubYou should write another Sub

Sub ShowMessage1 ()
MsgBox "metteur au point your code"
End SubAnd 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 (http://mymemory.translated.net/)

peter_martin
01-16-2016, 06:23 AM
Thank you SamT