{"id":1955,"date":"2023-10-26T12:11:59","date_gmt":"2023-10-26T12:11:59","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/verr\/"},"modified":"2023-12-06T05:57:16","modified_gmt":"2023-12-06T05:57:16","slug":"verr","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/verr\/","title":{"rendered":"Hoe de vba cver-functie gebruiken?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-291175789\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>De VBA CVERR-functie wordt vermeld in de vba-foutafhandelingscategorie van VBA-functies. Wanneer u het in VBA-code gebruikt, <strong>retourneert het een foutgegevenstype op basis van de code die u opgeeft<\/strong> . Simpel gezegd: met CVRR kunt u een soort fout in het resultaat krijgen. Bekijk deze foutcodes <a href=\"https:\/\/www.vba-market.com\/list-of-vba-error-codes\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">hier<\/a> .<\/p><h2 class=\"wp-block-heading\"> Syntaxis<\/h2><p> <strong>CVErr(Expressie)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumenten<\/h2><ul><li> <strong>Expressie<\/strong> : Foutcode waarvan u het foutgegevenstype wilt weten.<\/li><\/ul><h2 class=\"wp-block-heading\"> Voorbeeld<\/h2><p> Om praktisch te begrijpen hoe u de VBA CVERR-functie kunt gebruiken, moet u het onderstaande voorbeeld doorlopen waarin we er een vba-code mee hebben geschreven: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"voorbeeld-vba-cveer-functie\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-cveer-function\" width=\"786\" height=\"526\"><\/figure><\/div><p> In de bovenstaande code hebben we CVERR en de IF-voorwaarde gebruikt om te testen, waarbij wordt gecontroleerd of de waarde in cel A2 nul is of niet, en als dat zo is, hebben we de code voor fout 11 opgegeven (11 is de fout gegevenstype dat deling door nul vertegenwoordigt) naar de functie om het foutgegevenstype te retourneren.<\/p><h2 class=\"wp-block-heading\"> Opmerkingen<\/h2><ul><li> Als het argument dat u als foutcode instelt geen foutcode is en anders dan een getal, retourneert VBA runtimefout 13.<\/li><li> En als het argument dat u instelt een getal is maar geen foutcode, retourneert VBA een runtimefout 5.<\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1955","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hoe gebruik ik de VBA CVER-functie? (Syntaxis + voorbeeld)<\/title>\n<meta name=\"description\" content=\"Leer hoe u de VBA CVERR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/verr\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe gebruik ik de VBA CVER-functie? (Syntaxis + voorbeeld)\" \/>\n<meta property=\"og:description\" content=\"Leer hoe u de VBA CVERR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/verr\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:57:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/verr\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/verr\/\",\"name\":\"Hoe gebruik ik de VBA CVER-functie? (Syntaxis + voorbeeld)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/verr\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/verr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\",\"datePublished\":\"2023-10-26T12:11:59+00:00\",\"dateModified\":\"2023-12-06T05:57:16+00:00\",\"description\":\"Leer hoe u de VBA CVERR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/verr\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/verr\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/verr\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/verr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe de vba cver-functie gebruiken?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe gebruik ik de VBA CVER-functie? (Syntaxis + voorbeeld)","description":"Leer hoe u de VBA CVERR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/verr\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe gebruik ik de VBA CVER-functie? (Syntaxis + voorbeeld)","og_description":"Leer hoe u de VBA CVERR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","og_url":"https:\/\/exceladvisor.org\/nl\/verr\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:57:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/verr\/","url":"https:\/\/exceladvisor.org\/nl\/verr\/","name":"Hoe gebruik ik de VBA CVER-functie? (Syntaxis + voorbeeld)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/verr\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/verr\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png","datePublished":"2023-10-26T12:11:59+00:00","dateModified":"2023-12-06T05:57:16+00:00","description":"Leer hoe u de VBA CVERR-functie gebruikt met syntaxis, argumenten en voorbeelden met voorbeeldcode.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/verr\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/verr\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/verr\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/verr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe de vba cver-functie gebruiken?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1955","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1955"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1955\/revisions"}],"predecessor-version":[{"id":2371,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1955\/revisions\/2371"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}