How do I RUN A MACRO AT THE POINT OF CELL SELECTION?

[Bikeit]

Can anybody tell me how I can make a macro run automatically at the point a user selects a cell on the worksheet before entering any data whether it is blank or not?

Thanks in advance.

 

[Ivan F Moala]

On 2002-05-13 07:11, Bikeit wrote:
Can anybody tell me how I can make a macro run automatically at the point a user selects a cell on the worksheet before entering any data whether it is blank or not?

Thanks in advance.

Right Click on the Sheets tab you want to
have the macro run in.

Insert/paste this code in;

<pre/>
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
RunMyMacro
End If
End Sub
</pre>

This is a Sheet Event procedure and runs when
there is a change in the sheets selection.
In this case a Macro Named [RunMyMacro] is
called when ever A1 is selected, A1 being
the Target to watch for in this example.

 

[Bikeit]

Ivan, thanks for the reply. I know how to that bit, but it requires me to enter something into the cell first. What I need to do is run the macro at the point of selecting the cell with the mouse pointer.
Pehaps it's daft as pointed out by friendly asfgfhgabcdsillyperson or whoever.

 

[Vas]

On 2002-05-13 08:17, Bikeit wrote:
...it requires me to enter something into the cell first. What I need to do is run the macro at the point of selecting the cell with the mouse pointer.

Isn't that just what SelectionChange does?
Try
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
MsgBox "A"
End Sub

And you'll see that the msgbox appears as soon as you just change the selection.

 

[Ivan F Moala]

On 2002-05-13 08:17, Bikeit wrote:
Ivan, thanks for the reply. I know how to that bit, but it requires me to enter something into the cell first. What I need to do is run the macro at the point of selecting the cell with the mouse pointer.
Pehaps it's daft as pointed out by friendly asfgfhgabcdsillyperson or whoever.

Did you try it ?? code fires when the cell
A1 is selected via mouse selection or keying
over to it.

 

[Bikeit]

Cheers guys, thats sorted things out.
Your help has been very much appreciated.
Ivan..thanks for the email correspondence.