Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I: launch a macro if two cells do not equak one another?
Its late in the day and I am frustrated not getting this simple
procedure to work: I need a macro to fire when two cells in two different worksheets do nto equal one another. Here is my code: (that does not work....nothing happens at all) _________ Private Sub Workbook_SheetChange(ByVal Sh As Object, _ ByVal Source As Range) If Worksheets("Sheet1").Range("A2").Value = Worksheets("Sheet2").Range("D2").Value Then ' Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "values do not match." Style = vbOKOnly Title = "No Match" Response = MsgBox(Msg, Style, Title, Help, Ctxt) ' ' [lauches new sub routine] End If _________________ Do I have the wrong event or something?! --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Launch of Macro | Excel Discussion (Misc queries) | |||
Macro to launch web page | Excel Discussion (Misc queries) | |||
How do I Launch a Macro on a different sheet | Excel Programming | |||
auto-launch a MACRO? | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |