{"id":11627,"date":"2022-09-26T17:30:05","date_gmt":"2022-09-26T08:30:05","guid":{"rendered":"https:\/\/prodskill.com\/?p=11627"},"modified":"2022-10-04T23:07:30","modified_gmt":"2022-10-04T14:07:30","slug":"excel-vba-coding-pattern-performance-improvement","status":"publish","type":"post","link":"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/","title":{"rendered":"VBA-Codierungsmuster: Verbesserung der VBA-Leistung"},"content":{"rendered":"<p>In diesem Artikel sehen wir uns an, wie Sie die VBA-Leistung verbessern k\u00f6nnen.<\/p>\n\n\n\n<p>Im vorherigen Artikel haben wir die VBA-Range-Loop-Methode verglichen und best\u00e4tigt, dass die Methode mit Variant Array die schnellste ist.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-range-loop-read\/\">VBA-Codierungsmuster: Bereichsschleife - Lesen<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Inhaltsverzeichnis&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Inhaltsverzeichnis umschalten\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Umschalten<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/#1_%EC%84%B1%EB%8A%A5_%EA%B4%80%EB%A0%A8_VBA_%EC%A0%84%EC%97%AD_%EB%B3%80%EC%88%98\" >1. Leistungsbezogene globale VBA-Variablen<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/#11_ApplicationScreenUpdating\" >1.1. Anwendung Bildschirmaktualisierung<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/#12_ApplicationDisplayAlerts\" >1.2. Anwendung.DisplayAlerts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/#13_ApplicationCalculation\" >1.3. Anwendung Berechnung<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/#14_ApplicationEnableEvents\" >1.4. Anwendung EnableEvents<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/#2_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\" >2. Beispielcode<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/#21_%EC%A0%81%EC%9A%A9%EC%9D%B4_%EC%A0%81%ED%95%A9%ED%95%9C_%EA%B2%BD%EC%9A%B0\" >2.1. Wann ist eine Bewerbung sinnvoll<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/#22_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\" >2.2. Beispielcode<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"1._\uc131\ub2a5_\uad00\ub828_VBA_\uc804\uc5ed_\ubcc0\uc218\"><span class=\"ez-toc-section\" id=\"1_%EC%84%B1%EB%8A%A5_%EA%B4%80%EB%A0%A8_VBA_%EC%A0%84%EC%97%AD_%EB%B3%80%EC%88%98\"><\/span>1. Leistungsbezogene globale VBA-Variablen<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Hier ist eine Zusammenfassung aller Variablen.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\"><img loading=\"lazy\" decoding=\"async\" width=\"802\" height=\"345\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\" alt=\"\uc131\ub2a5 \uad00\ub828 VBA \uc804\uc5ed \ubcc0\uc218\" class=\"wp-image-11628\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png 802w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-300x129.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-768x330.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-24x10.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-36x15.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-48x21.png 48w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/a><figcaption>Leistungsbezogene globale VBA-Variablen<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Untersuchen Sie den Inhalt jeder Variablen.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.1._Application.ScreenUpdating\"><span class=\"ez-toc-section\" id=\"11_ApplicationScreenUpdating\"><\/span>1.1. Anwendung Bildschirmaktualisierung<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es ist eine Variable, die steuert, ob der Bildschirm aktualisiert wird oder nicht, und der Standardwert ist True (Bildschirm wird aktualisiert).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Leistungsverbesserung durch Einstellung, den Bildschirm w\u00e4hrend der VBA-Codeausf\u00fchrung nicht zu aktualisieren (Dateikonvertierung, Blattkonvertierung, Zellwerteinstellung usw.).<\/li><li>Effektiv bei vielen Bildschirmaktualisierungen<\/li><li>Setzen Sie es bei der Eingabe des Codes auf False und am Ende des Codes wieder auf True.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.2._Application.DisplayAlerts\"><span class=\"ez-toc-section\" id=\"12_ApplicationDisplayAlerts\"><\/span>1.2. Anwendung.DisplayAlerts<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Eine Variable, die steuert, ob das Warnfenster angezeigt wird oder nicht, und der Standardwert ist True (Warnfenster wird angezeigt).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Verhindert, dass der Code mittendrin anh\u00e4lt, indem keine Warnfenster angezeigt werden (z. B. das Fenster \u201eM\u00f6chten Sie speichern\u201c, wenn Sie versuchen, eine von Ihnen ge\u00e4nderte Datei zu schlie\u00dfen) w\u00e4hrend der Ausf\u00fchrung des VBA-Codes<\/li><li>Setzen Sie es bei der Eingabe des Codes auf False und am Ende des Codes wieder auf True.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.3._Application.Calculation\"><span class=\"ez-toc-section\" id=\"13_ApplicationCalculation\"><\/span>1.3. Anwendung Berechnung<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Dies ist eine Variable, die die Formelberechnungsmethode steuert, und der Standardwert ist xlCalculationAutomatic (automatische Berechnung).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Automatische Berechnung von Formeln (COUNTIF, SVERWEIS usw.) w\u00e4hrend der Ausf\u00fchrung von VBA-Code verhindern<\/li><li>Wirksam f\u00fcr viele Formeln<\/li><li>Setzen Sie es bei der Eingabe des Codes auf xlCalculationManual und am Ende des Codes wieder auf xlCalculationAutomatic<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.4._Application.EnableEvents\"><span class=\"ez-toc-section\" id=\"14_ApplicationEnableEvents\"><\/span>1.4. Anwendung EnableEvents<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Es ist eine Variable, die steuert, ob Ereignisse verarbeitet werden, und der Standardwert ist True (Ereignisse werden verarbeitet).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Ausf\u00fchrung von Code verhindern, der Ereignisse wie Worksheet_Change behandelt, wenn sie auftreten<\/li><li>Dies ist effektiv, wenn Sie \u00fcber Code verf\u00fcgen, der Ereignisse verarbeitet.<\/li><li>Setzen Sie es bei der Eingabe des Codes auf False und am Ende des Codes wieder auf True.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2._\uc608\uc2dc_\ucf54\ub4dc\"><span class=\"ez-toc-section\" id=\"2_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\"><\/span>2. Beispielcode<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.1._\uc801\uc6a9\uc774_\uc801\ud569\ud55c_\uacbd\uc6b0\"><span class=\"ez-toc-section\" id=\"21_%EC%A0%81%EC%9A%A9%EC%9D%B4_%EC%A0%81%ED%95%A9%ED%95%9C_%EA%B2%BD%EC%9A%B0\"><\/span>2.1. Wann ist eine Bewerbung sinnvoll<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Wenn der VBA-Code die folgenden F\u00e4lle enth\u00e4lt, ist es angebracht, die in diesem Artikel beschriebene Methode zur Leistungsverbesserung anzuwenden.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Beim Erstellen einer neuen Datei\/eines neuen Blattes<\/li><li>Beim Wechseln des aktuellen Blattes zu einem anderen Blatt<\/li><li>Im Falle einer kontinuierlichen \u00c4nderung der aktuell ausgew\u00e4hlten Zelle innerhalb eines Blattes<\/li><li>Bei der Durchf\u00fchrung komplexer Berechnungen, z. B. langer Berechnungen mit vielen Formeln<\/li><\/ul>\n\n\n\n<p>In diesem Fall wird die Ausf\u00fchrung des VBA-Codes vor\u00fcbergehend ausgesetzt und Ereignisse, die Excel erfordern, wie z. B. das Aktualisieren des Bildschirms oder das Berechnen von Formeln, werden verarbeitet. Das typischste Beispiel f\u00fcr langsamen VBA-Code ist die Bildschirmaktualisierung. Sie k\u00f6nnen die Leistung verbessern, indem Sie andere Ereignisverarbeitungen vor\u00fcbergehend aussetzen, w\u00e4hrend der VBA-Code ausgef\u00fchrt wird, und andere Ereignisse verarbeiten, nachdem die Ausf\u00fchrung des VBA-Codes abgeschlossen ist.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.2._\uc608\uc2dc_\ucf54\ub4dc\"><span class=\"ez-toc-section\" id=\"22_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\"><\/span>2.2. Beispielcode<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Vor der Eingabe des zu verarbeitenden Codes wird die globale Variable auf einen Leistungsverbesserungswert gesetzt, und nachdem der Verarbeitungscode beendet ist, wird sie auf den urspr\u00fcnglichen Wert ge\u00e4ndert. Bitte beachten Sie den folgenden Code.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'\ucf54\ub4dc \uc9c4\uc785 \ubd80\ubd84\nApplication.ScreenUpdating = False\nApplication.Calculation = xlCalculationManual\nApplication.EnableEvents = False\nApplication.DisplayAlerts = False\n\u00a0\n'\uc2e4\ud589\ud560 \ucf54\ub4dc\uac00 \ub4e4\uc5b4 \uac08 \ubd80\ubd84\n...\n\u00a0\n'\ucf54\ub4dc \uc885\ub8cc \ubd80\ubd84\nApplication.ScreenUpdating = True\nApplication.Calculation = xlCalculationAutomatic\nApplication.EnableEvents = True\nApplication.DisplayAlerts = True<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>Oben haben wir uns VBA-Codierungsmuster zur Leistungsverbesserung angesehen. Wenn Sie Fragen haben, hinterlassen Sie bitte einen Kommentar.<\/p>","protected":false},"excerpt":{"rendered":"<p>In diesem Artikel sehen wir uns an, wie Sie die VBA-Leistung verbessern k\u00f6nnen. Im vorherigen Artikel haben wir die VBA-Range-Loop-Methode verglichen und best\u00e4tigt, dass die Methode mit Variant Array die schnellste ist. VBA-Codierungsmuster: Bereichsschleife - Lesen 1. Leistungsbezogene globale VBA-Variablen Hier ist eine Zusammenfassung aller Variablen ....<\/p>","protected":false},"author":1,"featured_media":11628,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[17,74,75,96],"class_list":["post-11627","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-coding-pattern","tag-vba","tag-74","tag-codding-pattern","tag-96"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-26T08:30:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:07:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"345\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"3\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1\",\"datePublished\":\"2022-09-26T08:30:05+00:00\",\"dateModified\":\"2022-10-04T14:07:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"},\"wordCount\":98,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"keywords\":[\"\uc5d1\uc140VBA\",\"\ucf54\ub529\ud328\ud134\",\"Codding Pattern\",\"\uc131\ub2a5 \ud5a5\uc0c1\"],\"articleSection\":[\"\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\",\"name\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"datePublished\":\"2022-09-26T08:30:05+00:00\",\"dateModified\":\"2022-10-04T14:07:30+00:00\",\"description\":\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"width\":802,\"height\":345},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/de\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA-Codierungsmuster: Verbesserung der VBA-Leistung \u2013 Produktivit\u00e4tsf\u00e4higkeiten","description":"Dieser Artikel untersucht M\u00f6glichkeiten zur Verbesserung der Excel VBA-Leistung. Sie erfahren mehr \u00fcber vier globale VBA-Variablen, die sich auf die Leistung auswirken (ScreenUpdating, DisplayAlerts, Calculation und EnableEvents), sowie Beispielcode.","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:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/","og_locale":"de_DE","og_type":"article","og_title":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/de\/excel-vba-coding-pattern-performance-improvement\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-26T08:30:05+00:00","article_modified_time":"2022-10-04T14:07:30+00:00","og_image":[{"width":802,"height":345,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Zerom","Gesch\u00e4tzte Lesezeit":"3\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1","datePublished":"2022-09-26T08:30:05+00:00","dateModified":"2022-10-04T14:07:30+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"},"wordCount":98,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","keywords":["\uc5d1\uc140VBA","\ucf54\ub529\ud328\ud134","Codding Pattern","\uc131\ub2a5 \ud5a5\uc0c1"],"articleSection":["\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/","url":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/","name":"VBA-Codierungsmuster: Verbesserung der VBA-Leistung \u2013 Produktivit\u00e4tsf\u00e4higkeiten","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","datePublished":"2022-09-26T08:30:05+00:00","dateModified":"2022-10-04T14:07:30+00:00","description":"Dieser Artikel untersucht M\u00f6glichkeiten zur Verbesserung der Excel VBA-Leistung. Sie erfahren mehr \u00fcber vier globale VBA-Variablen, die sich auf die Leistung auswirken (ScreenUpdating, DisplayAlerts, Calculation und EnableEvents), sowie Beispielcode.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","width":802,"height":345},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Produktivit\u00e4tsf\u00e4higkeiten","description":"Meta-Denken, Meta-Arbeiten","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Nullm","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/de\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11627","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/comments?post=11627"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/posts\/11627\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media\/11628"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/media?parent=11627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/categories?post=11627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/de\/wp-json\/wp\/v2\/tags?post=11627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}