vba compile error

[ww4612]

Hello
I have confronted an vba compile error, while making an userform. my code is the following

Private Sub CommandButton1_Click()
name.Value = ""
you.Value = ""
destination.Value = ""
region.Value = ""
country.Value = ""
month.Value = ""
year.Value = ""
qa.Value = False
qn.Value = False
purpose.Value = "Remarks (optional)"
applicants.Value = ""
position.Value = ""
email.Value = ""
phone.Value = ""
fax.Value = ""
address.Value = ""
population.Value = ""
surface.Value = ""
shore.Value = ""
popuR.Value = ""
surfR.Value = ""
shoR.Value = ""
A.Value = ""
B.Value = ""
C.Value = ""
D.Value = ""
End
End Sub

qa, qn are optionbutton
month, year are combobox
the rest are all textbox
please help me.

 

[wigi]

Care to tell us what line of code?

 

[AlphaFrog]

name
month
year
address

...are all commands or properties used in VBA. Change those Control names.

Also delete the End command (2nd to last line in your code).

Best practice is to add a prefix to the control name that designates what type of control it its e.g.; tbName would be a textbox control.

 

[ww4612]

Care to tell us what line of code?

the system highlight the first line in the code which is

Private Sub CommandButton1_Click()

 

[ww4612]

to be more exact, the system says that the error is invalid qualification

 

[ww4612]

name
month
year
address

...are all commands or properties used in VBA. Change those Control names.

Also delete the End command (2nd to last line in your code).

Best practice is to add a prefix to the control name that designates what type of control it its e.g.; tbName would be a textbox control.

that actually worked. thank you. by the way, could you tell me what is the prefix control name for the other items, like option button, combobox

 

[AlphaFrog]

that actually worked. thank you. by the way, could you tell me what is the prefix control name for the other items, like option button, combobox

The prefixes could be anything you like.

Here is a suggested list.
Object Naming Conventions