ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   field validation (https://www.excelbanter.com/excel-discussion-misc-queries/31836-field-validation.html)

daolb

field validation
 

I want the show a message when de inserted value is different from "ok",
"nok or "nvt". I tried with the standard functionality validation, but
until now without succes.

I'm not an VBA specialist.
grtz

david


--
daolb
------------------------------------------------------------------------
daolb's Profile: http://www.excelforum.com/member.php...o&userid=24478
View this thread: http://www.excelforum.com/showthread...hreadid=381144


Dave Peterson

Maybe you could use Data|Validation and not even use VBA.

See Debra Dalgleish's site for more info:
http://www.contextures.com/xlDataVal01.html

daolb wrote:

I want the show a message when de inserted value is different from "ok",
"nok or "nvt". I tried with the standard functionality validation, but
until now without succes.

I'm not an VBA specialist.
grtz

david

--
daolb
------------------------------------------------------------------------
daolb's Profile: http://www.excelforum.com/member.php...o&userid=24478
View this thread: http://www.excelforum.com/showthread...hreadid=381144


--

Dave Peterson


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com