i am trying to find out what to write so that when you hit the cancel
button on the input box, nothing else happens. the cancel box will go
away.

here is my code


Dim deleteline As Integer
Dim count As Integer
count = 1
deleteline = InputBox("Enter Item Line to Delete")
Do While Range("f8").Offset(deleteline + count - 1) 0
Range("g8").Offset(deleteline + count - 1, 0) =
Range("g8").Offset(deleteline + count, 0)
Range("i8").Offset(deleteline + count - 1, 0) =
Range("i8").Offset(deleteline + count, 0)
count = count + 1
Loop
Range("f8").Offset(deleteline + count - 1, 0) = ""
Range("a1") = Range("a1") - 1
Range("f8").Offset(Range("a1") + 1, 0) = ""


--
kckar
------------------------------------------------------------------------
kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322
View this thread: http://www.excelforum.com/showthread...hreadid=533353