Error: Wrong number of arguments or invalid property assignment in VBA 6.0

752
1
04-04-2013 06:25 AM
MichelleCouden1
Occasional Contributor III
I am getting and erro of wrong number of arguments in my code. I am not understanding why. Please help!!


Private Sub cboStations_Change()

           
      If cboStations.Text = "Urban" Then
          cboYear.Clear
      cboYear.AddItem >>> right here is the error>>> "2010", "2011", "2012"
     
     
      End If
     
       
       
End Sub
Private Sub cboYear_Change()

    
    
     If cboYear.Text = "2010" Then
          cboDistrict.Clear
     cboDistrict.AddItem "Abilene", "Amarillo", "Austin", "San_Antonio", "Waco", "Wichita_Falls"
     Else
     If cboYear.Text = "2011" Then
          cboDistrict.Clear
     cboDistrict.AddItem "Beaumont", "Houston"
     Else
     If cboYear.Text = "2012" Then
          cboDistrict.Clear
     cboDistrict.AddItem "Brownwood", "Bryan", "Childress", "Corpus_Christi", "El_Paso", "Lubbock", "Odessa", "Yoakum"
    
     End If
0 Kudos
1 Reply
NeilClemmons
Regular Contributor III
You can only add one item at a time with the AddItem method.
0 Kudos