{"id":5654,"date":"2019-12-22T16:37:10","date_gmt":"2019-12-22T15:37:10","guid":{"rendered":"https:\/\/ditfirma.dk\/?p=5654"},"modified":"2019-12-22T16:37:10","modified_gmt":"2019-12-22T15:37:10","slug":"tilpas-regneark-og-dokumenter-med-vba","status":"publish","type":"post","link":"https:\/\/ditfirma.dk\/?p=5654","title":{"rendered":"Tilpas regneark og dokumenter med VBA"},"content":{"rendered":"<p><img src='https:\/\/wsnonline.dk\/storage\/editorials\/editorial.png' alt='editorial' style='padding:0;margin:0;height:auto;display:block;'><\/p>\n<p>Dr&oslash;mmer du om selv at kunne tilpasse dine Microsoft Office applikationer s&aring; som Microsoft Word og Microsoft Excel, s&aring; de passer til din anvendelse og dit work flow? S&aring; har du muligheden med Microsoft Visual Basic for Applications.<\/p>\n<h3>Hvorn&aring;r bruger man Microsoft Visual Basic for Applications?<\/h3>\n<p>Microsoft Visual Basic for Applications er en s&aelig;rdeles praktisk foranstaltning, n&aring;r det handler om at lave individuelle og skr&aelig;ddersyede tilpasninger af Microsoft Office applikationer. Det kan for eksempel v&aelig;re, at du ikke kan n&oslash;jes med de indbyggede beregnings funktioner i Microsoft Excel, men har brug for at kunne foretage mere avancerede operationer.<\/p>\n<p><img decoding=\"async\" style=\"width: 255px; height: 266px; display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/wsnonline.dk\/image-gallery-images\/pixabay-24956.png\" \/><\/p>\n<p>I stedet for at skulle udf&oslash;re en masse manuelle indtastninger og udregninger &ndash; med risiko for &oslash;get fejl margin til f&oslash;lge &ndash; kan du med Microsoft Visual Basic for Applications nemt og hurtigt tilf&oslash;je dine formler til regnearkets standard funktioner. Du kan bygge makroer og automatiserede processer i s&aring;vel Microsoft Excel som Microsoft Word, og dermed g&oslash;re dine applikationer og dokumenter mere intelligente. Og opererer du med slutbrugere, kan du bygge dialog bokse, som g&oslash;r disse opm&aelig;rksomme p&aring; s&aelig;rlige forhold omkring regnearkets eller dokumentets opbygning.<\/p>\n<h3>Hvor kan jeg l&aelig;re at bruge Microsoft Visual Basic for Applications?<\/h3>\n<p>Hvis du synes det kunne v&aelig;re sp&aelig;ndende at l&aelig;re hvorledes man tilpasser sine Microsoft Office applikationer ved hj&aelig;lp af Microsoft Visual Basic for Applications, kan du blive skarpere p&aring; dette med et kursus i Microsoft Visual Basic for Applications hos 4D.<\/p>\n<p>4D er en af Danmarks st&oslash;rste og mest velrenommerede kursus udbydere, og har gennem de seneste &aring;r specialiseret sig i IT kurser rettet mod erhvervslivet &ndash; her under s&aelig;rligt Microsoft Office pakken. Du finder blandt andet Microsoft Visual Basic for Applications kurser, som adresserer brugen af Microsoft Visual Basic for Applications i applikationer s&aring; som Microsoft Access, Microsoft Excel, Microsoft Visio, Microsoft Visual Studio, og Microsoft Word.<\/p>\n<p>Du kan finde samtlige <a href=\"https:\/\/www.4d.dk\/kurser\/office\/vba\" target=\"_blank\" rel=\"noopener\">vba kurser<\/a> p&aring; 4d.dk<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dr&oslash;mmer du om selv at kunne tilpasse dine Microsoft Office applikationer s&aring; som Microsoft Word og Microsoft Excel, s&aring; de passer til din anvendelse og dit work flow? S&aring; har du muligheden med Microsoft Visual Basic for Applications. Hvorn&aring;r bruger man Microsoft Visual Basic for Applications? Microsoft Visual Basic for Applications er en s&aelig;rdeles praktisk [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":5655,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[11],"class_list":["post-5654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-inspiration","tag-inspiration"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tilpas regneark og dokumenter med VBA - ditfirma.dk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ditfirma.dk\/?p=5654\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tilpas regneark og dokumenter med VBA - ditfirma.dk\" \/>\n<meta property=\"og:description\" content=\"Dr&oslash;mmer du om selv at kunne tilpasse dine Microsoft Office applikationer s&aring; som Microsoft Word og Microsoft Excel, s&aring; de passer til din anvendelse og dit work flow? S&aring; har du muligheden med Microsoft Visual Basic for Applications. Hvorn&aring;r bruger man Microsoft Visual Basic for Applications? Microsoft Visual Basic for Applications er en s&aelig;rdeles praktisk [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ditfirma.dk\/?p=5654\" \/>\n<meta property=\"og:site_name\" content=\"ditfirma.dk\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-22T15:37:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wsnonline.dk\/storage\/editorials\/editorial.png\" \/>\n<meta name=\"author\" content=\"Sofie S\u00f8rensen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Skriven av\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sofie S\u00f8rensen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Ber\u00e4knad l\u00e4stid\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654\"},\"author\":{\"name\":\"Sofie S\u00f8rensen\",\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/#\\\/schema\\\/person\\\/dc58944b9a8450561e61030582339f7f\"},\"headline\":\"Tilpas regneark og dokumenter med VBA\",\"datePublished\":\"2019-12-22T15:37:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654\"},\"wordCount\":370,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ditfirma.dk\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/pixabay-1356793.png\",\"keywords\":[\"inspiration\"],\"articleSection\":[\"inspiration\"],\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ditfirma.dk\\\/?p=5654#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654\",\"url\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654\",\"name\":\"Tilpas regneark og dokumenter med VBA - ditfirma.dk\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ditfirma.dk\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/pixabay-1356793.png\",\"datePublished\":\"2019-12-22T15:37:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/#\\\/schema\\\/person\\\/dc58944b9a8450561e61030582339f7f\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ditfirma.dk\\\/?p=5654\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654#primaryimage\",\"url\":\"https:\\\/\\\/ditfirma.dk\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/pixabay-1356793.png\",\"contentUrl\":\"https:\\\/\\\/ditfirma.dk\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/pixabay-1356793.png\",\"width\":1000,\"height\":707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/?p=5654#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ditfirma.dk\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tilpas regneark og dokumenter med VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/#website\",\"url\":\"https:\\\/\\\/ditfirma.dk\\\/\",\"name\":\"ditfirma.dk\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ditfirma.dk\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sv-SE\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ditfirma.dk\\\/#\\\/schema\\\/person\\\/dc58944b9a8450561e61030582339f7f\",\"name\":\"Sofie S\u00f8rensen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/948fba1f71349c32a1f10a80133bd05c2f31d7770dd1ef4d0a615776b2140cb3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/948fba1f71349c32a1f10a80133bd05c2f31d7770dd1ef4d0a615776b2140cb3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/948fba1f71349c32a1f10a80133bd05c2f31d7770dd1ef4d0a615776b2140cb3?s=96&d=mm&r=g\",\"caption\":\"Sofie S\u00f8rensen\"},\"description\":\"Superdygtig og kreativ grafisk designer med en livslang passion for det visuelle udtryk. Jeg har tegnet og malet siden barndommen, hvilket har givet mig et veludviklet &oslash;je for form, farver, komposition og &aelig;stetik. Denne kunstneriske baggrund kombinerer jeg med en professionel tilgang til digitalt design, hvor jeg skaber l&oslash;sninger, der er b&aring;de funktionelle og visuelt tiltalende. Jeg har stor erfaring med grafiske designprogrammer som Adobe Creative Suite, herunder Photoshop, Illustrator og InDesign, og arbejder med alt fra branding og visuel identitet til layout og digitalt indhold. Mit fokus er altid p&aring; at skabe designs, der kommunikerer klart, v&aelig;kker f&oslash;lelser og underst&oslash;tter virksomhedens budskab.\",\"url\":\"https:\\\/\\\/ditfirma.dk\\\/?author=11\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tilpas regneark og dokumenter med VBA - ditfirma.dk","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:\/\/ditfirma.dk\/?p=5654","og_locale":"sv_SE","og_type":"article","og_title":"Tilpas regneark og dokumenter med VBA - ditfirma.dk","og_description":"Dr&oslash;mmer du om selv at kunne tilpasse dine Microsoft Office applikationer s&aring; som Microsoft Word og Microsoft Excel, s&aring; de passer til din anvendelse og dit work flow? S&aring; har du muligheden med Microsoft Visual Basic for Applications. Hvorn&aring;r bruger man Microsoft Visual Basic for Applications? Microsoft Visual Basic for Applications er en s&aelig;rdeles praktisk [&hellip;]","og_url":"https:\/\/ditfirma.dk\/?p=5654","og_site_name":"ditfirma.dk","article_published_time":"2019-12-22T15:37:10+00:00","og_image":[{"url":"https:\/\/wsnonline.dk\/storage\/editorials\/editorial.png","type":"","width":"","height":""}],"author":"Sofie S\u00f8rensen","twitter_card":"summary_large_image","twitter_misc":{"Skriven av":"Sofie S\u00f8rensen","Ber\u00e4knad l\u00e4stid":"2 minuter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ditfirma.dk\/?p=5654#article","isPartOf":{"@id":"https:\/\/ditfirma.dk\/?p=5654"},"author":{"name":"Sofie S\u00f8rensen","@id":"https:\/\/ditfirma.dk\/#\/schema\/person\/dc58944b9a8450561e61030582339f7f"},"headline":"Tilpas regneark og dokumenter med VBA","datePublished":"2019-12-22T15:37:10+00:00","mainEntityOfPage":{"@id":"https:\/\/ditfirma.dk\/?p=5654"},"wordCount":370,"commentCount":0,"image":{"@id":"https:\/\/ditfirma.dk\/?p=5654#primaryimage"},"thumbnailUrl":"https:\/\/ditfirma.dk\/wp-content\/uploads\/2019\/12\/pixabay-1356793.png","keywords":["inspiration"],"articleSection":["inspiration"],"inLanguage":"sv-SE","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ditfirma.dk\/?p=5654#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ditfirma.dk\/?p=5654","url":"https:\/\/ditfirma.dk\/?p=5654","name":"Tilpas regneark og dokumenter med VBA - ditfirma.dk","isPartOf":{"@id":"https:\/\/ditfirma.dk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ditfirma.dk\/?p=5654#primaryimage"},"image":{"@id":"https:\/\/ditfirma.dk\/?p=5654#primaryimage"},"thumbnailUrl":"https:\/\/ditfirma.dk\/wp-content\/uploads\/2019\/12\/pixabay-1356793.png","datePublished":"2019-12-22T15:37:10+00:00","author":{"@id":"https:\/\/ditfirma.dk\/#\/schema\/person\/dc58944b9a8450561e61030582339f7f"},"breadcrumb":{"@id":"https:\/\/ditfirma.dk\/?p=5654#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ditfirma.dk\/?p=5654"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/ditfirma.dk\/?p=5654#primaryimage","url":"https:\/\/ditfirma.dk\/wp-content\/uploads\/2019\/12\/pixabay-1356793.png","contentUrl":"https:\/\/ditfirma.dk\/wp-content\/uploads\/2019\/12\/pixabay-1356793.png","width":1000,"height":707},{"@type":"BreadcrumbList","@id":"https:\/\/ditfirma.dk\/?p=5654#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ditfirma.dk\/"},{"@type":"ListItem","position":2,"name":"Tilpas regneark og dokumenter med VBA"}]},{"@type":"WebSite","@id":"https:\/\/ditfirma.dk\/#website","url":"https:\/\/ditfirma.dk\/","name":"ditfirma.dk","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ditfirma.dk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sv-SE"},{"@type":"Person","@id":"https:\/\/ditfirma.dk\/#\/schema\/person\/dc58944b9a8450561e61030582339f7f","name":"Sofie S\u00f8rensen","image":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/secure.gravatar.com\/avatar\/948fba1f71349c32a1f10a80133bd05c2f31d7770dd1ef4d0a615776b2140cb3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/948fba1f71349c32a1f10a80133bd05c2f31d7770dd1ef4d0a615776b2140cb3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/948fba1f71349c32a1f10a80133bd05c2f31d7770dd1ef4d0a615776b2140cb3?s=96&d=mm&r=g","caption":"Sofie S\u00f8rensen"},"description":"Superdygtig og kreativ grafisk designer med en livslang passion for det visuelle udtryk. Jeg har tegnet og malet siden barndommen, hvilket har givet mig et veludviklet &oslash;je for form, farver, komposition og &aelig;stetik. Denne kunstneriske baggrund kombinerer jeg med en professionel tilgang til digitalt design, hvor jeg skaber l&oslash;sninger, der er b&aring;de funktionelle og visuelt tiltalende. Jeg har stor erfaring med grafiske designprogrammer som Adobe Creative Suite, herunder Photoshop, Illustrator og InDesign, og arbejder med alt fra branding og visuel identitet til layout og digitalt indhold. Mit fokus er altid p&aring; at skabe designs, der kommunikerer klart, v&aelig;kker f&oslash;lelser og underst&oslash;tter virksomhedens budskab.","url":"https:\/\/ditfirma.dk\/?author=11"}]}},"_links":{"self":[{"href":"https:\/\/ditfirma.dk\/index.php?rest_route=\/wp\/v2\/posts\/5654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ditfirma.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ditfirma.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ditfirma.dk\/index.php?rest_route=\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/ditfirma.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5654"}],"version-history":[{"count":0,"href":"https:\/\/ditfirma.dk\/index.php?rest_route=\/wp\/v2\/posts\/5654\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ditfirma.dk\/index.php?rest_route=\/wp\/v2\/media\/5655"}],"wp:attachment":[{"href":"https:\/\/ditfirma.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ditfirma.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ditfirma.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}