<div>
instead of the messagebox you can place your macro to run in there like <br />
<br />
If Target.Address = &quot;$Z$&quot; &amp;&nbsp;i Then<br />
&nbsp; &nbsp;call macro1 &nbsp; <br />
End If<br />

</div>


instead of the messagebox you can place your macro to run in there like

If Target.Address = "$Z$" & i Then
   call macro1  
End If


<div>
<div class="content wysiwyg-content">
Hello again. &nbsp;I was needing to find out. &nbsp;How do i go about setting up a macro that will run, whenever the one of the &nbsp;cells are selected on sheets &quot;data&quot; cell z1 or z2 or z3 or z4 or z5 or z6. &nbsp;Thanks
</div>
</div>


Hello again.  I was needing to find out.  How do i go about setting up a macro that will run, whenever the one of the  cells are selected on sheets "data" cell z1 or z2 or z3 or z4 or z5 or z6.  Thanks

Excel VBA

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.