Macro on exit cell

[nonshedders]

G'day Everyone,

This may be simple, but it has this basic user flummoxed: how do I set up a cell so that, once data is entered and the cell is exited, a macro is performed using the data?

cheers,

nonshedders

[Otto Moehrbach]

Do you mean how is a macro executed when data is entered into a specific
cell? How do you want the exiting of the cell to play into this? To
execute a macro when data is entered into a specific cell, you would use a
Worksheet_Change macro like the following. I chose F3 as the specific cell
and a macro named TheMacro as the macro you want executed..
Note that, as written, TheMacro will fire if data is entered only in F3. If
you want TheMacro executed when data is entered into any cell in a range of
cells, then the macro below will have to be changed to reflect that and you
might need to pass the cell address and /or cell value to TheMacro when you
call it. Post back if you need more. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub
If Target.Address(0, 0) = "F3" Then Call TheMacro
End Sub
"nonshedders" <[email protected]>
wrote in message
news:[email protected]...
>
> G'day Everyone,
>
> This may be simple, but it has this basic user flummoxed: how do I set
> up a cell so that, once data is entered and the cell is exited, a macro
> is performed using the data?
>
> cheers,
>
> nonshedders
>
>
> --
> nonshedders
> ------------------------------------------------------------------------
> nonshedders's Profile:
> http://www.excelforum.com/member.php...o&userid=33397
> View this thread: http://www.excelforum.com/showthread...hreadid=532203
>