How do I capture CANCEL on an Inputbox?
 

Excel 2002 SP3
Windows XP Pro SP2

I can do it on a MsgBox, but can't figure it out on an InputBox. Anyone?

-gk-

How do I capture CANCEL on an Inputbox?
 

Check to see if the string returned is "".

dim myStr as string
mystr = inputbox("hi")
if mystr = "" then
'user hit cancel
exit sub
end if


Toxicdistortion wrote:

Excel 2002 SP3
Windows XP Pro SP2

I can do it on a MsgBox, but can't figure it out on an InputBox. Anyone?

-gk-

--

Dave Peterson

How do I capture CANCEL on an Inputbox?
 

Doh!

Thank you!


"Dave Peterson" wrote in message
...
Check to see if the string returned is "".

dim myStr as string
mystr = inputbox("hi")
if mystr = "" then
'user hit cancel
exit sub
end if


Toxicdistortion wrote:

Excel 2002 SP3
Windows XP Pro SP2

I can do it on a MsgBox, but can't figure it out on an InputBox. Anyone?

-gk-

--

Dave Peterson

How do I capture CANCEL on an Inputbox?
 

Doh!

Thank you!


"Dave Peterson" wrote in message
...
Check to see if the string returned is "".

dim myStr as string
mystr = inputbox("hi")
if mystr = "" then
'user hit cancel
exit sub
end if


Toxicdistortion wrote:

Excel 2002 SP3
Windows XP Pro SP2

I can do it on a MsgBox, but can't figure it out on an InputBox. Anyone?

-gk-

--

Dave Peterson