Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Instr function
In cell A1 I have: The Sky is blue
In the input box I enter blue After running the below (99 times) i get - Didn't Find it! - 99 times !!! Why? Sub Foo() Dim T As Integer Dim Z As String Z = InputBox("Enter key word") 'enter blue T = InStr(1, Z, ActiveSheet.Range("A1"), vbTextCompare) If Temp 0 Then MsgBox "Found it!" Else MsgBox "Didn't Find it!" End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with VBA InStr() function | Excel Discussion (Misc queries) | |||
InStr function | Excel Programming | |||
InStr Function | Excel Programming | |||
InStr Function Question | Excel Programming | |||
InStr function question | Excel Programming |