same cell multiplied by set value

[Guest]

A simple calculation of...the value entered multiplied by a number..
eg. Cell A1, put in value .5, it then multiplies by 1000 and gives 500 in
cell A1

please advise

 

[JE McGimpsey]

One way:

Put this in your worksheet code module (right-click the worksheet tab
and choose View Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address(False, False) = "A1" Then
Application.EnableEvents = False
.Value = .Value * 1000#
Application.EnableEvents = True
End If
End Sub