Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default msgbox appear with error msg


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

--
jrd26
-----------------------------------------------------------------------
jrd269's Profile: http://www.excelforum.com/member.php...fo&userid=2381
View this thread: http://www.excelforum.com/showthread.php?threadid=37597

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default msgbox appear with error msg

Look at

Data=Validation

in the menu.

--
Regards,
Tom Ogilvy

"jrd269" wrote in
message ...

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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default msgbox appear with error msg

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

--
HTH

Bob Phillips

"jrd269" wrote in
message ...

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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default msgbox appear with error msg


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

--
jrd26
-----------------------------------------------------------------------
jrd269's Profile: http://www.excelforum.com/member.php...fo&userid=2381
View this thread: http://www.excelforum.com/showthread.php?threadid=37597

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MsgBox when an Error occurs Vick Excel Discussion (Misc queries) 1 December 21st 05 08:48 PM
MsgBox compile error in Excell Jerry Dyben Excel Discussion (Misc queries) 1 October 11th 05 07:04 PM
msgbox on error Ciara Excel Discussion (Misc queries) 6 May 26th 05 08:34 PM
MsgBox Code Error MBlake Excel Programming 8 May 2nd 05 11:16 PM
inputbox msgbox error lost again Excel Programming 3 April 14th 04 07:56 PM


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"