Hello, I get the error (when i get to the line which include
"Me.txtStreet.Value") in the title when i try to run the below cod
(which is in an excel 97 document)... and I can't see anything wron
with it... the "Me.txtStreet.Value" is equal to "Street A." Also, th
lstClientInformation.ColumnCount is set to 22. Any help i
appreciated.

'// Add item to listbox
With Me.lstClientInformation
.AddItem strClientName '// Client Name
.List(.ListCount - 1, 1) = Me.txtFarmBusinessStableName.Valu
'// Farm/Business/Stable Name
.List(.ListCount - 1, 2) = strMailingAddress '// Mailin
Address
.List(.ListCount - 1, 3) = Me.txtSalutation.Value '/
Salutation
.List(.ListCount - 1, 4) = Me.txtFirstName.Value '// Firs
Name
.List(.ListCount - 1, 5) = Me.txtMiddleInitials.Value '/
Middle Initial(s)
.List(.ListCount - 1, 6) = Me.txtLastName.Value '// Last Name
.List(.ListCount - 1, 7) = Me.txtFarmBusinessStableName.Valu
'// FSB Name
.List(.ListCount - 1, 8) = Me.txtStreetNumber.Value '// Stree
Number
.List(.ListCount - 1, 9) = Me.txtUnitNumber.Value '// Uni
Number
.List(.ListCount - 1, 10) = Me.txtStreet.Value '// Street
.List(.ListCount - 1, 11) = Me.txtAddress2.Value '// Address 2
.List(.ListCount - 1, 12) = Me.txtCity.Value '// City
Me.cboProvince.BoundColumn = 1
.List(.ListCount - 1, 13) = Me.cboProvince.Value '// Provinc
ID
Me.cboProvince.BoundColumn = 2
.List(.ListCount - 1, 14) = Me.cboProvince.Value '// Provinc
Name
.List(.ListCount - 1, 15) = Me.txtPostalCode.Value '// Posta
Code
.List(.ListCount - 1, 16) = Me.txtPhone.Value '// Phone Number
.List(.ListCount - 1, 17) = Me.txtExtension.Value '// Phon
Extension
.List(.ListCount - 1, 18) = Me.txtCell.Value '// Cell Number
.List(.ListCount - 1, 19) = Me.txtPager.Value '// Pager Number
.List(.ListCount - 1, 20) = Me.txtFax.Value '// Fax Number
.List(.ListCount - 1, 21) = Me.txtEmailAddress.Value '// Emai
Address

End With


Thanks,


Jason Grandmaiso

--
jasgran
-----------------------------------------------------------------------
jasgrand's Profile: http://www.excelforum.com/member.php...fo&userid=1507
View this thread: http://www.excelforum.com/showthread.php?threadid=26702