msgbox appear with error msg

I am hitting a wall right now. for example, how do you display a msgbox when a user enters an incorrect value. just a simple msgbox with an okbtn. I haven't had enough coffee.
-Joe

nevermind, i got it, i am going back to bed.

Look at

Data=>Validation

in the menu.

--
Regards,
Tom Ogilvy

"jrd269" <jrd269.1q08ak_1117724718.4566@excelforum-nospam.com> wrote in
message news:jrd269.1q08ak_1117724718.4566@excelforum-nospam.com...
>
> I am hitting a wall right now. for example, how do you display a msgbox
> when a user enters an incorrect value. just a simple msgbox with an
> okbtn. I haven't had enough coffee.
> -Joe
>
>
> --
> jrd269
> ------------------------------------------------------------------------
> jrd269's Profile:
http://www.excelforum.com/member.php...o&userid=23815
> View this thread: http://www.excelforum.com/showthread...hreadid=375974
>

Look at data validation http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"jrd269" <jrd269.1q08ak_1117724718.4566@excelforum-nospam.com> wrote in
message news:jrd269.1q08ak_1117724718.4566@excelforum-nospam.com...
>
> I am hitting a wall right now. for example, how do you display a msgbox
> when a user enters an incorrect value. just a simple msgbox with an
> okbtn. I haven't had enough coffee.
> -Joe
>
>
> --
> jrd269
> ------------------------------------------------------------------------
> jrd269's Profile:
http://www.excelforum.com/member.php...o&userid=23815
> View this thread: http://www.excelforum.com/showthread...hreadid=375974
>