Thread: cancel input
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ME @ Home
 
Posts: n/a
Default cancel input

have the following line of code

Dim reg As String
Range(locatereg).Select

reg = InputBox("Confirm Registration Number For " & Range(locatetrunk) &
Chr$(13) & Chr$(13), "Reg", Range(locatereg))

how do i get the imput box to exit the sub if cancel is pressed,, as it does
if using msgbox