<div>
yep vikram is right, follow his instruction<br />
<br />
Private Sub Workbook_SheetSelectionCha<wbr />nge(ByVal Sh _<br />
As Object, ByVal Target As Excel.Range)<br />
&nbsp; &nbsp;<br />
&nbsp; &nbsp; MsgBox &quot;change&quot;<br />
&nbsp; &nbsp; 'put your code to run your macro<br />
End Sub
</div>


yep vikram is right, follow his instruction

Private Sub Workbook_SheetSelectionChange(ByVal Sh _
As Object, ByVal Target As Excel.Range)
   
    MsgBox "change"
    'put your code to run your macro
End Sub

<div>
Thanks for the info Vikram, <br />
<br />
Liam
</div>


<div>
<div class="content wysiwyg-content">
I have a macro in excel 2002 which I has to be run every time a value in certain portion of a worksheet changes. &nbsp;Rather than having to select this to run every time a value in the work sheet changes, I would rather that the macro would run automatically every time a value in this selected area changes.<br />
<br />
Thanks for all your help<br />
<br />
Liam McGrath<br />

</div>
</div>


I have a macro in excel 2002 which I has to be run every time a value in certain portion of a worksheet changes.  Rather than having to select this to run every time a value in the work sheet changes, I would rather that the macro would run automatically every time a value in this selected area changes.

Thanks for all your help

Liam McGrath


Automating VBA in excel 2002

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.