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
Printable View
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
"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.