I have written the program to classify nos 1-4 as short, 4-8 as medium and 9,10 as long. The output shows all nos as long. Please help
Sub casestatements()
Dim filmname As String
Dim filmlength As Integer
Dim filmtype As String
filmname = Application.InputBox("Select the film", Type:=0)
filmlength = ActiveCell.Offset(0, 1).Value
Select Case filmlength
Case 1, 2, 3, 4
filmtype = "short"
Case 5, 6, 7, 8
filmtype = "medium"
Case Else
7 filmtype = "Long"
End Select
MsgBox filmname & " is " & filmtype
End Sub
Bookmarks