| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I, in VBA, test to see if a cell has a specific word in it
I need to know what text is in an cell. The cell will be used to determine what sheet will be edited with the macro. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I, in VBA, test to see if a cell has a specific word in it
A bit more info -- Don Guillett Microsoft MVP Excel SalesAid Software "The Inspector" <The wrote in message ... I need to know what text is in an cell. The cell will be used to determine what sheet will be edited with the macro. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I, in VBA, test to see if a cell has a specific word in it
Sub SelectSheet() If ActiveCell.Value = MyValue Then Sheets("MyValue").Select Else Sheets("NotMyValue").Select End If End Sub Hope this helps. "The Inspector" wrote: I need to know what text is in an cell. The cell will be used to determine what sheet will be edited with the macro. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I, in VBA, test to see if a cell has a specific word in it
do you mean If ActiveCell.Value = "MyValue" Then otherwise MyValue becomes a variable, defaulting to null and the IF condition will always be False "Brad" wrote in message ... Sub SelectSheet() If ActiveCell.Value = MyValue Then Sheets("MyValue").Select Else Sheets("NotMyValue").Select End If End Sub Hope this helps. "The Inspector" wrote: I need to know what text is in an cell. The cell will be used to determine what sheet will be edited with the macro. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I, in VBA, test to see if a cell has a specific word in
Thanks guys "Patrick Molloy" wrote: do you mean If ActiveCell.Value = "MyValue" Then otherwise MyValue becomes a variable, defaulting to null and the IF condition will always be False "Brad" wrote in message ... Sub SelectSheet() If ActiveCell.Value = MyValue Then Sheets("MyValue").Select Else Sheets("NotMyValue").Select End If End Sub Hope this helps. "The Inspector" wrote: I need to know what text is in an cell. The cell will be used to determine what sheet will be edited with the macro. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calcuting sum of specific word "P" within specific cell range (A5: | Excel Worksheet Functions | |||
| Highlight a cell with a specific word in it | Excel Worksheet Functions | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| Extracting specific word in a cell | Excel Worksheet Functions | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
Linear Mode
