Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for text string
Hi! I have a macro that searches through a list of data using objects. I want
to see if a cell contains a certain value and if so then do something. The cell can contain eg: AUSTRIA GVB 2012 JUL 5.0%. However, I am just interested in AUSTRIA. The rest does not matter. I have a list of the words I am looking for. Basically all I want to know is how can I search a cell for a certain value? Thanks alot!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for text string
Hello Arne
Dim Rg As Range With Range("A1:E1") Set Rg = .Find("AUSTRIA", LookIn:=xlValues, lookat:=xlPart) If Not Rg Is Nothing Then MsgBox "Value found in " & Rg.Address End If End With See VBA help for further info on Find method. HTH Cordially Pascal "Arne Hegefors" a écrit dans le message de news: ... Hi! I have a macro that searches through a list of data using objects. I want to see if a cell contains a certain value and if so then do something. The cell can contain eg: AUSTRIA GVB 2012 JUL 5.0%. However, I am just interested in AUSTRIA. The rest does not matter. I have a list of the words I am looking for. Basically all I want to know is how can I search a cell for a certain value? Thanks alot!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for text string
The code below will return a message mox saying "yup" of A1 contains
AUSTRIA anywhere within it's text. Sub try() If InStr(1, Cells(1,1), "AUSTRIA", 1) _ Then MsgBox "yup" End Sub Arne Hegefors wrote: Hi! I have a macro that searches through a list of data using objects. I want to see if a cell contains a certain value and if so then do something. The cell can contain eg: AUSTRIA GVB 2012 JUL 5.0%. However, I am just interested in AUSTRIA. The rest does not matter. I have a list of the words I am looking for. Basically all I want to know is how can I search a cell for a certain value? Thanks alot!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search If on text string | Excel Worksheet Functions | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Search for a text string | Excel Discussion (Misc queries) | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
Search a text file for a string | Excel Programming |