{"id":2063,"date":"2023-10-21T12:39:59","date_gmt":"2023-10-21T12:39:59","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/"},"modified":"2023-12-06T05:49:19","modified_gmt":"2023-12-06T05:49:19","slug":"scherm-bijwerken","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/","title":{"rendered":"Hoe kan ik schermupdates in vba in- en uitschakelen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1590283124\"><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> <h2 class=\"wp-block-heading\">Wat is VBA-schermupdate?<\/h2><p> ScreenUpdating is een eigenschap in VBA die u kunt gebruiken om het bijwerken van schermen &#8220;AAN&#8221; en &#8220;UIT&#8221; te zetten tijdens het uitvoeren van code. U kunt het uitschakelen voordat u code uitvoert die de uitvoering van uw code versnelt, en het vervolgens weer inschakelen nadat de code is uitgevoerd. U kunt deze eigenschap lezen en schrijven. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55686\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-schermupdate\" width=\"512\" height=\"332\"><\/figure><\/div><p> Standaard is schermupdate \u201cAAN\u201d in Excel. Wanneer u <a href=\"https:\/\/exceladvisor.org\/nl\/voer-een-macro-uit-2\/\">een code normaal uitvoert,<\/a> duurt het veel flikkeren als die code lang duurt, maar als u schermupdates uitschakelt, duurt het uitvoeren ervan minder lang dan normaal.<\/p><h2 class=\"wp-block-heading\"> Schakel schermupdate uit in VBA<\/h2><ol type=\"1\"><li> Typ eerst het trefwoord \u2018Toepassing\u2019.<\/li><li> Tik daarna op een \u201c. \u00bb om de lijst met eigenschappen en methoden te openen.<\/li><li> Selecteer nu \u201cSchermupdate\u201d.<\/li><li> Geef aan het einde &#8216;False&#8217; op. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55687\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-desactiver-la-mise-a-jour-de-lecran.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"463\" height=\"180\"><\/figure><\/div><p> Nadat u het bijwerken van het scherm hebt uitgeschakeld, zal VBA dit niet meer inschakelen nadat de code is uitgevoerd. Het is dus altijd beter om het aan uw kant uit te schakelen. De code zou er ongeveer zo uitzien als hieronder. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55688\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-desactiver-la-mise-a-jour-de-lecran.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"477\" height=\"363\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Dingen om te overwegen<\/h2><ul><li> Zorg ervoor dat het scherm is bijgewerkt naar &#8220;AAN&#8221; wanneer u een gebruikersformulier gebruikt.<\/li><li> Als u fouten in de code opspoort, kunt u het beste een updatescherm &#8216;AAN&#8217; hebben, zodat u alle activiteiten kunt zien zoals ze zijn.<\/li><\/ul><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/vba\/\">Wat is VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/markeer-dubbele-waarden\/\">Markeer dubbele waarden met VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/hyperlink-uitpakken\/\">Extraheer hyperlinkadres (URL) VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/invoerveld\/\">Invoervak in VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tekstbestanden\/\">VBA maken en schrijven naar een tekstbestand<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","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-2063","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 kan ik schermupdates in VBA in- en uitschakelen?<\/title>\n<meta name=\"description\" content=\"Wat is VBA-schermupdate? Leer hoe u schermupdates in VBA kunt in- en uitschakelen.\" \/>\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\/scherm-bijwerken\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe kan ik schermupdates in VBA in- en uitschakelen?\" \/>\n<meta property=\"og:description\" content=\"Wat is VBA-schermupdate? Leer hoe u schermupdates in VBA kunt in- en uitschakelen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:49:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.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\/scherm-bijwerken\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/\",\"name\":\"Hoe kan ik schermupdates in VBA in- en uitschakelen?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\",\"datePublished\":\"2023-10-21T12:39:59+00:00\",\"dateModified\":\"2023-12-06T05:49:19+00:00\",\"description\":\"Wat is VBA-schermupdate? Leer hoe u schermupdates in VBA kunt in- en uitschakelen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe kan ik schermupdates in vba in- en uitschakelen?\"}]},{\"@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 kan ik schermupdates in VBA in- en uitschakelen?","description":"Wat is VBA-schermupdate? Leer hoe u schermupdates in VBA kunt in- en uitschakelen.","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\/scherm-bijwerken\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe kan ik schermupdates in VBA in- en uitschakelen?","og_description":"Wat is VBA-schermupdate? Leer hoe u schermupdates in VBA kunt in- en uitschakelen.","og_url":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:49:19+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.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\/scherm-bijwerken\/","url":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/","name":"Hoe kan ik schermupdates in VBA in- en uitschakelen?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png","datePublished":"2023-10-21T12:39:59+00:00","dateModified":"2023-12-06T05:49:19+00:00","description":"Wat is VBA-schermupdate? Leer hoe u schermupdates in VBA kunt in- en uitschakelen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/scherm-bijwerken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe kan ik schermupdates in vba in- en uitschakelen?"}]},{"@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\/2063","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=2063"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2063\/revisions"}],"predecessor-version":[{"id":2607,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2063\/revisions\/2607"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}