software

have the following line of code

Dim reg As String
Range(locatereg).Select

reg = InputBox(quot;Confirm Registration Number For quot; amp; Range(locatetrunk) amp;
Chr$(13) amp; Chr$(13), quot;Regquot;, Range(locatereg))

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

Dim reg As String
Range(locatereg).Select

reg = InputBox(quot;Confirm Registration Number For quot; amp; _
Range(locatetrunk) amp; vbNewLine amp; vbNewLine, _
quot;Regquot;, Range(locatereg))

If reg lt;gt; quot;quot; Then
...--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;ME @ Homequot; gt; wrote in message
...
gt; have the following line of code
gt;
gt; Dim reg As String
gt; Range(locatereg).Select
gt;
gt; reg = InputBox(quot;Confirm Registration Number For quot; amp; Range(locatetrunk) amp;
gt; Chr$(13) amp; Chr$(13), quot;Regquot;, Range(locatereg))
gt;
gt; how do i get the imput box to exit the sub if cancel is pressed,, as it
does
gt; if using msgbox