Hi,

I am trying to do a simple sum using inputs taken from userform
comboboxes. The problem is that the inputs can contain the text
character "-", and this is causing an error. I have tried converting
the inputs to values using val, cval, cdec, etc, but I think that the
problem is that the application.sum function in VBA, like the simple
operation "+", can't handle text. Any ideas about how to deal with
this?

Thanks!
-Tim

The Worksheet function SUM() (which you call as Application.Sum) does
handle text by ignoring it. But you said you're converting the inputs to
(numeric) values. Does that not work?

Perhaps some examples of what you're doing would help to clarify the
problem...

In article om,
Smurfette18 wrote:

Hi,

I am trying to do a simple sum using inputs taken from userform
comboboxes. The problem is that the inputs can contain the text
character "-", and this is causing an error. I have tried converting
the inputs to values using val, cval, cdec, etc, but I think that the
problem is that the application.sum function in VBA, like the simple
operation "+", can't handle text. Any ideas about how to deal with
this?

Thanks!
-Tim

=sum() adds numbers.

Strings like: 1234+34-3465-2345+(1234/2143)
aren't numbers

But maybe you could use application.evaluate() to evaluate a string that looks
like a formula.



Smurfette18 wrote:

Hi,

I am trying to do a simple sum using inputs taken from userform
comboboxes. The problem is that the inputs can contain the text
character "-", and this is causing an error. I have tried converting
the inputs to values using val, cval, cdec, etc, but I think that the
problem is that the application.sum function in VBA, like the simple
operation "+", can't handle text. Any ideas about how to deal with
this?

Thanks!
-Tim

--

Dave Peterson

MsgBox Val(TextBox1.Text) + Val(TextBox2.Text)

works for me

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Smurfette18" wrote in message
ps.com...
Hi,

I am trying to do a simple sum using inputs taken from userform
comboboxes. The problem is that the inputs can contain the text
character "-", and this is causing an error. I have tried converting
the inputs to values using val, cval, cdec, etc, but I think that the
problem is that the application.sum function in VBA, like the simple
operation "+", can't handle text. Any ideas about how to deal with
this?

Thanks!
-Tim

Sumproduct is smarter than sum. Try this function

=SUMPRODUCT((--VALUE(A1:A3)))

"Dave Peterson" wrote:

=sum() adds numbers.

Strings like: 1234+34-3465-2345+(1234/2143)
aren't numbers

But maybe you could use application.evaluate() to evaluate a string that looks
like a formula.



Smurfette18 wrote:

Hi,

I am trying to do a simple sum using inputs taken from userform
comboboxes. The problem is that the inputs can contain the text
character "-", and this is causing an error. I have tried converting
the inputs to values using val, cval, cdec, etc, but I think that the
problem is that the application.sum function in VBA, like the simple
operation "+", can't handle text. Any ideas about how to deal with
this?

Thanks!
-Tim

--

Dave Peterson

I got the impression that the OP was getting formula like strings in the
textboxes in a userform. If my guess is correct, then I don't think this is
better.

And if the values in that range are really strings that look like:
1234+345+234
Then I don't think =sum() or =sumproduct() will help.

Joel wrote:

Sumproduct is smarter than sum. Try this function

=SUMPRODUCT((--VALUE(A1:A3)))

"Dave Peterson" wrote:

=sum() adds numbers.

Strings like: 1234+34-3465-2345+(1234/2143)
aren't numbers

But maybe you could use application.evaluate() to evaluate a string that looks
like a formula.



Smurfette18 wrote:

Hi,

I am trying to do a simple sum using inputs taken from userform
comboboxes. The problem is that the inputs can contain the text
character "-", and this is causing an error. I have tried converting
the inputs to values using val, cval, cdec, etc, but I think that the
problem is that the application.sum function in VBA, like the simple
operation "+", can't handle text. Any ideas about how to deal with
this?

Thanks!
-Tim

--

Dave Peterson


--

Dave Peterson