Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement
Hi,
I am a novice with VBA and am trying to put an if statement which detects whether the cell contains the word "total" within the cell (there will be text before and after it). I have tried : If ActiveCell.value = "*total*" Then but this doesn't work. Many Thanks in advance Pete |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement
try
If InStr(ActiveCell, "total") 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Pete" wrote in message ... Hi, I am a novice with VBA and am trying to put an if statement which detects whether the cell contains the word "total" within the cell (there will be text before and after it). I have tried : If ActiveCell.value = "*total*" Then but this doesn't work. Many Thanks in advance Pete |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement
The first will find "total" and the second will find nothing (since the
variable TOTAL) is uninitialized, but assuming you meant If InStr(ActiveCell, UCase("TOTAL")) 0 Then MsgBox "its there" it would find only TOTAL to do a case insensitive search You probably meant If InStr(Ucase(ActiveCell), "TOTAL") 0 Then MsgBox "its there" or better: if Instr(1,ActiveCell,"total",vbTextCompare) then MsgBox "its there" End If -- Regards, Tom Ogilvy "Don Guillett" wrote in message ... Or this to account for case If InStr(ActiveCell, UCase(TOTAL)) 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Don Guillett" wrote in message ... try If InStr(ActiveCell, "total") 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Pete" wrote in message ... Hi, I am a novice with VBA and am trying to put an if statement which detects whether the cell contains the word "total" within the cell (there will be text before and after it). I have tried : If ActiveCell.value = "*total*" Then but this doesn't work. Many Thanks in advance Pete |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement
this is what I meant
If InStr(Ucase(ActiveCell), "TOTAL") 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Tom Ogilvy" wrote in message ... The first will find "total" and the second will find nothing (since the variable TOTAL) is uninitialized, but assuming you meant If InStr(ActiveCell, UCase("TOTAL")) 0 Then MsgBox "its there" it would find only TOTAL to do a case insensitive search You probably meant If InStr(Ucase(ActiveCell), "TOTAL") 0 Then MsgBox "its there" or better: if Instr(1,ActiveCell,"total",vbTextCompare) then MsgBox "its there" End If -- Regards, Tom Ogilvy "Don Guillett" wrote in message ... Or this to account for case If InStr(ActiveCell, UCase(TOTAL)) 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Don Guillett" wrote in message ... try If InStr(ActiveCell, "total") 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Pete" wrote in message ... Hi, I am a novice with VBA and am trying to put an if statement which detects whether the cell contains the word "total" within the cell (there will be text before and after it). I have tried : If ActiveCell.value = "*total*" Then but this doesn't work. Many Thanks in advance Pete |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement
That works great !
Thanks for your help guys. Pete "Don Guillett" wrote: this is what I meant If InStr(Ucase(ActiveCell), "TOTAL") 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Tom Ogilvy" wrote in message ... The first will find "total" and the second will find nothing (since the variable TOTAL) is uninitialized, but assuming you meant If InStr(ActiveCell, UCase("TOTAL")) 0 Then MsgBox "its there" it would find only TOTAL to do a case insensitive search You probably meant If InStr(Ucase(ActiveCell), "TOTAL") 0 Then MsgBox "its there" or better: if Instr(1,ActiveCell,"total",vbTextCompare) then MsgBox "its there" End If -- Regards, Tom Ogilvy "Don Guillett" wrote in message ... Or this to account for case If InStr(ActiveCell, UCase(TOTAL)) 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Don Guillett" wrote in message ... try If InStr(ActiveCell, "total") 0 Then MsgBox "its there" -- Don Guillett SalesAid Software "Pete" wrote in message ... Hi, I am a novice with VBA and am trying to put an if statement which detects whether the cell contains the word "total" within the cell (there will be text before and after it). I have tried : If ActiveCell.value = "*total*" Then but this doesn't work. Many Thanks in advance Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |