S
steven
hi I have this part of a code:
If IsError(.Cells(Lrow, "E").Value) Then
ElseIf .Cells(Lrow, "E").Value = "2" And _
.Cells(Lrow, "G").Value <> 0 Then .Rows(Lrow).Delete
but instead of having value "2" i'd prefer to have a box pop up that askes
me for this value each time, something like this I guess:
Dim V As Variant
V = Application.InputBox(prompt:="Enter number of month.", Type:=1)
If V = False Then
Debug.Print "User clicked cancel"
but how do I combine the 2 parts of code? any suggestions?
S.
If IsError(.Cells(Lrow, "E").Value) Then
ElseIf .Cells(Lrow, "E").Value = "2" And _
.Cells(Lrow, "G").Value <> 0 Then .Rows(Lrow).Delete
but instead of having value "2" i'd prefer to have a box pop up that askes
me for this value each time, something like this I guess:
Dim V As Variant
V = Application.InputBox(prompt:="Enter number of month.", Type:=1)
If V = False Then
Debug.Print "User clicked cancel"
but how do I combine the 2 parts of code? any suggestions?
S.