fdavidgolf
New Member
- Joined
- Apr 23, 2002
- Messages
- 26
When the Asset Description is changed, I want Column E (Extended Price) to be a formula Unit Price * Quantity.
There could be any number of assets to enter.
Earlier John McGraw sent in a solution for Kourada on 4-23. This did not work for me.
The formula field is protected; however, I have tried it unprotected.
I thought it was working at first, now it doesn't.
The data starts on row 14.
Here is my code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$14" Then
If Target.Address.Value < "$B$64000" Then
FillExtPrice
End If
End If
End Sub
There could be any number of assets to enter.
Earlier John McGraw sent in a solution for Kourada on 4-23. This did not work for me.
The formula field is protected; however, I have tried it unprotected.
I thought it was working at first, now it doesn't.
The data starts on row 14.
Here is my code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$14" Then
If Target.Address.Value < "$B$64000" Then
FillExtPrice
End If
End If
End Sub