Thread: VBA Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas Price[_2_] Thomas Price[_2_] is offline
external usenet poster
 
Posts: 10
Default VBA Macro

I am trying to get cell (S5) to auto fill when you enter the weight of the
vehicle in cell (W5). If the vehicle weights 50,000 lbs or more it needs to
be classified as a "HEAVY TRUCK". If the weight is less than 50,000 it needs
to be classified as a "LT DUTY TRUCK". If there is no weight filled in I
want to manually enter the classification. My VBA macro I pasted into the
sheet is not working. Can anyone help me fix this? Thanks!

Here is what I have so far

Private Sub Worksheet_Change1(ByVal Target As Range)
If Intersect(Range("W5"), Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
If Target.Value = 0 Then
Exit Sub
End If
If Target.Value = 50000 Then
Range("S5").Value = "HEAVY TRUCK"
End If
If Target.Value < 50000 Then
Range("S5").Value = "LT DUTY TRUCK"
End If
Application.EnableEvents = True
End Sub