| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
StrComp numeric
When using this VB function :
If StrComp(Target.Offset(0, -3).Text, "Debit", vbTextCompare) = 0 Then How do I turn it into a numeric test? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
StrComp numeric
If you want to compare two numbers
If target.Offset(0,-3).Value 21 then If you mean case sensitive replace vbTextCompare with vbBinaryCompare Natrually strcomp is for comparing strings. -- Regards, Tom Ogilvy "Rick" wrote: When using this VB function : If StrComp(Target.Offset(0, -3).Text, "Debit", vbTextCompare) = 0 Then How do I turn it into a numeric test? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
StrComp numeric
Thanks Tom: I was thinking in the same direction, but did not realize .value
0 would work. "Tom Ogilvy" wrote: If you want to compare two numbers If target.Offset(0,-3).Value 21 then If you mean case sensitive replace vbTextCompare with vbBinaryCompare Natrually strcomp is for comparing strings. -- Regards, Tom Ogilvy "Rick" wrote: When using this VB function : If StrComp(Target.Offset(0, -3).Text, "Debit", vbTextCompare) = 0 Then How do I turn it into a numeric test? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| StrComp | Excel Programming | |||
| Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Linear Mode
