How do I, in VBA, test to see if a cell has a specific word in it

  • Thread starter Thread starter The Inspector
  • Start date Start date
T

The Inspector

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.
 
Sub SelectSheet()
If ActiveCell.Value = MyValue Then
Sheets("MyValue").Select
Else
Sheets("NotMyValue").Select
End If
End Sub

Hope this helps.
 
do you mean

If ActiveCell.Value = "MyValue" Then

otherwise MyValue becomes a variable, defaulting to null and the IF
condition will always be False
 
Thanks guys

Patrick Molloy said:
do you mean

If ActiveCell.Value = "MyValue" Then

otherwise MyValue becomes a variable, defaulting to null and the IF
condition will always be False
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Macro that will insert a simple text string in top cell of text file 1
Enter data in cell referenced in a cell 4
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Macro to Combine Data from Multiple Sheets with Cell References 4
Excel VBA help: Text file formatting 19

Back
Top