inputbox (error if close)

[CatherineN]

I am trying to put an input box in that wont let you just push cancel, somethign MUST be input. Right now when they push cancle it just has an error in the program, but this needs to be a little more user friendly. Can i do this by having a message box pop up saying you must enter something then close that and have the inputbox still be up, or have a new input box come up that says you must enter a value and have it loop until a value is input. I have no idea how to do this though, please help.

[Die_Another_Day]

Do
str1 = Application.InputBox("Testing","Blah Blah")
While str1 = False

HTH

Die_Another_Day
"CatherineN" <[email protected]> wrote
in message news:[email protected]...
>
> I am trying to put an input box in that wont let you just push cancel,
> somethign MUST be input. Right now when they push cancle it just has
> an error in the program, but this needs to be a little more user
> friendly. Can i do this by having a message box pop up saying you must
> enter something then close that and have the inputbox still be up, or
> have a new input box come up that says you must enter a value and have
> it loop until a value is input. I have no idea how to do this though,
> please help.
>
>
> --
> CatherineN
> ------------------------------------------------------------------------
> CatherineN's Profile:
> http://www.excelforum.com/member.php...o&userid=35469
> View this thread: http://www.excelforum.com/showthread...hreadid=560737
>

[colofnature]

"Do...While" isn't VBA. Use:

do while str1 = false
str1 = Application.InputBox("Testing", "Blah Blah")
loop


Col

[Jim Jackson]

If msgbox("Your Text") = VbCancel then
msgbox("You must enter some data"),VbOkOnly
else
end if
--
Best wishes,

Jim


"CatherineN" wrote:

>
> I am trying to put an input box in that wont let you just push cancel,
> somethign MUST be input. Right now when they push cancle it just has
> an error in the program, but this needs to be a little more user
> friendly. Can i do this by having a message box pop up saying you must
> enter something then close that and have the inputbox still be up, or
> have a new input box come up that says you must enter a value and have
> it loop until a value is input. I have no idea how to do this though,
> please help.
>
>
> --
> CatherineN
> ------------------------------------------------------------------------
> CatherineN's Profile: http://www.excelforum.com/member.php...o&userid=35469
> View this thread: http://www.excelforum.com/showthread...hreadid=560737
>
>

[CatherineN]

Thank you I got it to work, the logic makes sense, like any other programming language, but the syntax really still confuses me, so thanks for the help

[Die_Another_Day]

Sry... I just winged it without testing the code. The proper syntax is:
Do
str1 = Application.InputBox("Testing","Blah Blah")
Loop While str1 = False

Die_Another_Day
"colofnature" <[email protected]>
wrote in message
news:[email protected]...
>
> "Do...While" isn't VBA. Use:
>
> do while str1 = false
> str1 = Application.InputBox("Testing", "Blah Blah")
> loop
>
>
> Col
>
>
> --
> colofnature
> ------------------------------------------------------------------------
> colofnature's Profile:
> http://www.excelforum.com/member.php...o&userid=34356
> View this thread: http://www.excelforum.com/showthread...hreadid=560737
>