Run Excel Macro From Specific sheet Cell

[W. D. Allen Sr.]

Is it possible to run a macro to manipulate a number which has been entered
into a specific cell in a spreadsheet by hitting "enter" in that cell?

If so how is it done?

Thanks,

W. D. Allen Sr.

ballensr@home.com

end

[Willy Van den Driessche]

"W. D. Allen Sr." <ballensr@home.com> wrote:
>
>Is it possible to run a macro to manipulate a number which has been entered
>into a specific cell in a spreadsheet by hitting "enter" in that cell?
>
>If so how is it done?
>
>Thanks,
>
>W. D. Allen Sr.
>
>ballensr@home.com
>
>end
>

In my opinion you're in a completely wrong newsgroup. However, I would do
it with the WorkSheet.Change event, which is a standard event.

Private Sub Worksheet_Change(ByVal Target as Range)
Target.Font.ColorIndex = 5
End Sub

Unlike the example, you should check the range to be your cell and do the
action you want to do. Check out the other worksheet event functions too.