Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set rng for Column A only (ignores other columns) | Excel Programming | |||
Excel ignores "Text qualifiers" in Unicode files | Excel Discussion (Misc queries) | |||
formula ignores last infor - please help | Excel Worksheet Functions | |||
How do you use text in a formula so it will calc, but ignores txt | Excel Discussion (Misc queries) | |||
Min Value using array ignores Zero | Excel Discussion (Misc queries) |