IfThen Macro

[shasta]

What i'm tryin to do is:

When the user types in the number 2 in to a certain cell i want
particular sheet to cum up and if they type in any other number int
the cell then i want another sheet to pop up....the code that i trie
was

Sub EasyPeasyIF()


If (ActiveCell("H12") = (2)) Then

Sheets("Fantastic").Select

Else

Sheets("Oh no").Select

End If
End Sub

but its obvioulsy not correct....could someone please hel
me!!!!!!!:eek

 

[Harald Staff]

Hi

You want something to happen when you type something into a cell. That's an
"event macro". See Chip's sample
Worksheet_Change
at
http://www.cpearson.com/excel/events.htm

HTH. Best wishes Harald

 

[shasta]

thats wiked...thank you very much...its answered sum questions i din'
even realise i had....thank you!!!!! :