maybe something like this. Right click on the tab, then select view code.
Then paste this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$P$82" Then
Select Case Target.Value
Case 1
MsgBox "call a macro here"
Case 2
MsgBox "call a different macro here"
End Select
End If
End Sub



--
Hope that helps.

Vergel Adriano


" wrote:

Hello there (I'm back with the beginner questions)

Is there a way I could launch macros according to the value of a
cell? Being that I want a certain macro to launch if p82 is equal to
1, and a different to launch if p82 is equal to 2, etc... Visual Basic
is so frusturating (I wish it were C !! ;-) )