Adding Combobox Values
Maube they are all strings. Try
If Val(ComboBox6.Value) + Val(ComboBox8.Value) + Val(ComboBox10.Value) +
Val(ComboBox12.Value) _ Val(ComboBox14.Value) TextBox47.Value Then
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Corey" wrote in message
...
I have a problem with adding up the values selected in some comboboxes.
the code I was using that is NOT working is:
If ComboBox6.List(ComboBox6.ListIndex, 0) +
ComboBox8.List(ComboBox8.ListIndex, 0) +
ComboBox10.List(ComboBox10.ListIndex, 0) +
ComboBox12.List(ComboBox12.ListIndex, 0) +
ComboBox14.List(ComboBox14.ListIndex, 0) TextBox47.Value Then
Is there a problem with the above?
I get NIL Value from it.
The list Index is correct for each.
Corey....
|