That is perfect, exactly what I needed, thanks all!
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Can you live with VBA worksheet event code?
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in a cell in Col A
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
If Excel.Range("A" & n).Value < "" Then
Excel.Range("B" & n).Value = _
Target.Value / 425
End If
End If
enditall:
Application.EnableEvents = True
End Sub
Right-click on the sheet tab and "View Code".
Copy/paste the above code into that module.
When you enter a number such as 6500 in any cell in column A, the adjacent
cell in column B will show that number divided 425.
Gord Dibben Excel MVP
On Tue, 5 Jul 2005 14:46:02 -0400, "http://" wrote:
I am greatly in need of assistance. I have made up a sheet with all of
the
information I need but I do not know how to get it to work.
What I need to do is have the user enter a specific number representing a
load in pounds (6500 for example) then I need to have that number divided
by
another number (this will be 425 consistently). Then I need to have the
answer displayed so the user can compare it to a chart on the sheet and
match up the correct structural component needed.
I would certainly appreciate any help. I have very little knowledge of
Excel
so please make any responses dummy proof.
TIA
Joe
|