Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Box
Simple problem i know but i am hitting a blank with this one. I have a macro that reads: If Range("N57") = "" Then Else Before the Else i want a warning box in there instead ot the do nothing that is currently in there. I just want it to read something like "Please Enter a Value". any takers? -- chalky ------------------------------------------------------------------------ chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758 View this thread: http://www.excelforum.com/showthread...hreadid=509435 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Box
Hello Chalky, Try using an InputBox... If Range("M57") = "" Then Answer = InputBox("Please enter a value.") If Answer < "" Then Range("M57") = Answer Else .... End If Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=509435 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Box
Do
If Range("N57") = "" Then Range("N57").Value = Inputbox("Please Enter a Value") Else '... End If Loop Until Range("N57").Value < "" -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "chalky" wrote in message ... Simple problem i know but i am hitting a blank with this one. I have a macro that reads: If Range("N57") = "" Then Else Before the Else i want a warning box in there instead ot the do nothing that is currently in there. I just want it to read something like "Please Enter a Value". any takers? -- chalky ------------------------------------------------------------------------ chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758 View this thread: http://www.excelforum.com/showthread...hreadid=509435 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Box
If Range("N57") = "" Then
MsgBox "Please Enter Value" exit sub Else An Alternative Dim as as Variant If Range("N57") = "" Then ans = InputBox("Please Enter a Value for ""N57""") if not isnumeric(ans) then exit sub else Range("N57").Value = ans end if End if -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "chalky" wrote in message ... Simple problem i know but i am hitting a blank with this one. I have a macro that reads: If Range("N57") = "" Then Else Before the Else i want a warning box in there instead ot the do nothing that is currently in there. I just want it to read something like "Please Enter a Value". any takers? -- chalky ------------------------------------------------------------------------ chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758 View this thread: http://www.excelforum.com/showthread...hreadid=509435 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Form Err.Raise error not trapped by entry procedure error handler | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |