{"id":100112414,"date":"2024-09-09T09:00:00","date_gmt":"2024-09-09T06:00:00","guid":{"rendered":"https:\/\/europeanhealtheconomics.com\/?p=100112414"},"modified":"2026-09-11T11:45:37","modified_gmt":"2026-09-11T08:45:37","slug":"why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling","status":"publish","type":"post","link":"https:\/\/europeanhealtheconomics.com\/nl\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/","title":{"rendered":"Why Excel VBA is still your go-to tool for Health Economics Modelling"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Excel VBA is over 30 years old. It\u2019s still supported, but it\u2019s not getting significant updates anymore. Yet, many of us, as health economists, use VBA weekly. So, why does Excel VBA continue to be our go-to tool for building health economics models? <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let me share my thoughts. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Excel is widely used across both academia and industry, and most of us are already pretty familiar with it, which makes it a natural starting point. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Plus, the agencies reviewing our health economics submissions tend to have more expertise in Excel VBA than in other tools. They also appreciate the auditability of these models. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Even though it\u2019s old, it\u2019s still good software for our needs. With VBA, we can build, test, and refine our Excel models. Many health economists start with basic Excel functions and then move on to VBA to automate and enhance their models. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And maybe we just don\u2019t have another \u201cSwiss pocket knife\u201d alternative yet. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">See the latest <a href=\"https:\/\/europeanhealtheconomics.com\/nl\/job\/vba\/\">Excel VBA jobs for health economists<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Excel VBA is over 30 years old. It\u2019s still supported, but it\u2019s not getting significant updates anymore. Yet, many of us, as health economists, use VBA weekly. So, why does Excel VBA continue to be our go-to tool for building health economics models? Let me share my thoughts. Excel is widely used across both academia and industry, and most of &#8230; <a title=\"Why Excel VBA is still your go-to tool for Health Economics Modelling\" class=\"read-more\" href=\"https:\/\/europeanhealtheconomics.com\/nl\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/\" aria-label=\"Lees meer over Why Excel VBA is still your go-to tool for Health Economics Modelling\">Lees meer<\/a><\/p>","protected":false},"author":1,"featured_media":100110995,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3721],"tags":[],"class_list":["post-100112414","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","no-featured-image-padding","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Why Excel VBA is still your go-to tool for Health Economics Modelling<\/title>\n<meta name=\"description\" content=\"Why Excel VBA is still our go-to tool for Health Economics Modelling. Excel is widely used across both academia and industry.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/europeanhealtheconomics.com\/nl\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why Excel VBA is still your go-to tool for Health Economics Modelling\" \/>\n<meta property=\"og:description\" content=\"Why Excel VBA is still our go-to tool for Health Economics Modelling. Excel is widely used across both academia and industry.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/europeanhealtheconomics.com\/nl\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/\" \/>\n<meta property=\"og:site_name\" content=\"EuropeanHealthEconomics.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-09T06:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-11T08:45:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/europeanhealtheconomics.com\/wp-content\/uploads\/Excel-VBA-courses-for-health-economists.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Jari Kempers\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/\"},\"author\":{\"name\":\"Jari Kempers\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#\\\/schema\\\/person\\\/f3945683d2bd69dd755b2e0c03a3fd3b\"},\"headline\":\"Why Excel VBA is still your go-to tool for Health Economics Modelling\",\"datePublished\":\"2024-09-09T06:00:00+00:00\",\"dateModified\":\"2026-09-11T08:45:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/\"},\"wordCount\":181,\"publisher\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/wp-content\\\/uploads\\\/Excel-VBA-courses-for-health-economists.webp\",\"articleSection\":[\"Health Economics Blog\"],\"inLanguage\":\"nl-NL\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/\",\"url\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/\",\"name\":\"Why Excel VBA is still your go-to tool for Health Economics Modelling\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/wp-content\\\/uploads\\\/Excel-VBA-courses-for-health-economists.webp\",\"datePublished\":\"2024-09-09T06:00:00+00:00\",\"dateModified\":\"2026-09-11T08:45:37+00:00\",\"description\":\"Why Excel VBA is still our go-to tool for Health Economics Modelling. Excel is widely used across both academia and industry.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/#primaryimage\",\"url\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/wp-content\\\/uploads\\\/Excel-VBA-courses-for-health-economists.webp\",\"contentUrl\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/wp-content\\\/uploads\\\/Excel-VBA-courses-for-health-economists.webp\",\"width\":1000,\"height\":376},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Health Economics Blog\",\"item\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Why Excel VBA is still your go-to tool for Health Economics Modelling\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#website\",\"url\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/\",\"name\":\"EuropeanHealthEconomics.com\",\"description\":\"The specialised job board for Health Economists\",\"publisher\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#organization\"},\"alternateName\":\"European Health Economics\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#organization\",\"name\":\"EuropeanHealthEconomics.com\",\"alternateName\":\"European Health Economics\",\"url\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/wp-content\\\/uploads\\\/European-Health-Economics-the-specialised-health-economist-job-board.png\",\"contentUrl\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/wp-content\\\/uploads\\\/European-Health-Economics-the-specialised-health-economist-job-board.png\",\"width\":512,\"height\":512,\"caption\":\"EuropeanHealthEconomics.com\"},\"image\":{\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/europeanhealtheconomics.com\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/europeanhealtheconomics.com\\\/#\\\/schema\\\/person\\\/f3945683d2bd69dd755b2e0c03a3fd3b\",\"name\":\"Jari Kempers\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6433cb297f720dce97e1f2eebf492073b61167c05c8bb6c65a5f95e6315ec034?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6433cb297f720dce97e1f2eebf492073b61167c05c8bb6c65a5f95e6315ec034?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6433cb297f720dce97e1f2eebf492073b61167c05c8bb6c65a5f95e6315ec034?s=96&d=mm&r=g\",\"caption\":\"Jari Kempers\"},\"sameAs\":[\"https:\\\/\\\/europeanhealtheconomics.com\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/jarikempers\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/x.com\\\/EUROHEOR\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why Excel VBA is still your go-to tool for Health Economics Modelling","description":"Why Excel VBA is still our go-to tool for Health Economics Modelling. Excel is widely used across both academia and industry.","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:\/\/europeanhealtheconomics.com\/nl\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/","og_locale":"nl_NL","og_type":"article","og_title":"Why Excel VBA is still your go-to tool for Health Economics Modelling","og_description":"Why Excel VBA is still our go-to tool for Health Economics Modelling. Excel is widely used across both academia and industry.","og_url":"https:\/\/europeanhealtheconomics.com\/nl\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/","og_site_name":"EuropeanHealthEconomics.com","article_published_time":"2024-09-09T06:00:00+00:00","article_modified_time":"2026-09-11T08:45:37+00:00","og_image":[{"width":1000,"height":376,"url":"https:\/\/europeanhealtheconomics.com\/wp-content\/uploads\/Excel-VBA-courses-for-health-economists.webp","type":"image\/webp"}],"author":"Jari Kempers","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/#article","isPartOf":{"@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/"},"author":{"name":"Jari Kempers","@id":"https:\/\/europeanhealtheconomics.com\/#\/schema\/person\/f3945683d2bd69dd755b2e0c03a3fd3b"},"headline":"Why Excel VBA is still your go-to tool for Health Economics Modelling","datePublished":"2024-09-09T06:00:00+00:00","dateModified":"2026-09-11T08:45:37+00:00","mainEntityOfPage":{"@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/"},"wordCount":181,"publisher":{"@id":"https:\/\/europeanhealtheconomics.com\/#organization"},"image":{"@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/#primaryimage"},"thumbnailUrl":"https:\/\/europeanhealtheconomics.com\/wp-content\/uploads\/Excel-VBA-courses-for-health-economists.webp","articleSection":["Health Economics Blog"],"inLanguage":"nl-NL"},{"@type":"WebPage","@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/","url":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/","name":"Why Excel VBA is still your go-to tool for Health Economics Modelling","isPartOf":{"@id":"https:\/\/europeanhealtheconomics.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/#primaryimage"},"image":{"@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/#primaryimage"},"thumbnailUrl":"https:\/\/europeanhealtheconomics.com\/wp-content\/uploads\/Excel-VBA-courses-for-health-economists.webp","datePublished":"2024-09-09T06:00:00+00:00","dateModified":"2026-09-11T08:45:37+00:00","description":"Why Excel VBA is still our go-to tool for Health Economics Modelling. Excel is widely used across both academia and industry.","breadcrumb":{"@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/#primaryimage","url":"https:\/\/europeanhealtheconomics.com\/wp-content\/uploads\/Excel-VBA-courses-for-health-economists.webp","contentUrl":"https:\/\/europeanhealtheconomics.com\/wp-content\/uploads\/Excel-VBA-courses-for-health-economists.webp","width":1000,"height":376},{"@type":"BreadcrumbList","@id":"https:\/\/europeanhealtheconomics.com\/blog\/why-excel-vba-is-still-our-go-to-tool-for-health-economics-modelling\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/europeanhealtheconomics.com\/"},{"@type":"ListItem","position":2,"name":"Health Economics Blog","item":"https:\/\/europeanhealtheconomics.com\/blog\/"},{"@type":"ListItem","position":3,"name":"Why Excel VBA is still your go-to tool for Health Economics Modelling"}]},{"@type":"WebSite","@id":"https:\/\/europeanhealtheconomics.com\/#website","url":"https:\/\/europeanhealtheconomics.com\/","name":"EuropeanHealthEconomics.com","description":"De gespecialiseerde vacaturebank voor gezondheidseconomen","publisher":{"@id":"https:\/\/europeanhealtheconomics.com\/#organization"},"alternateName":"European Health Economics","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/europeanhealtheconomics.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/europeanhealtheconomics.com\/#organization","name":"EuropeanHealthEconomics.com","alternateName":"European Health Economics","url":"https:\/\/europeanhealtheconomics.com\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/europeanhealtheconomics.com\/#\/schema\/logo\/image\/","url":"https:\/\/europeanhealtheconomics.com\/wp-content\/uploads\/European-Health-Economics-the-specialised-health-economist-job-board.png","contentUrl":"https:\/\/europeanhealtheconomics.com\/wp-content\/uploads\/European-Health-Economics-the-specialised-health-economist-job-board.png","width":512,"height":512,"caption":"EuropeanHealthEconomics.com"},"image":{"@id":"https:\/\/europeanhealtheconomics.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/europeanhealtheconomics.com\/"]},{"@type":"Person","@id":"https:\/\/europeanhealtheconomics.com\/#\/schema\/person\/f3945683d2bd69dd755b2e0c03a3fd3b","name":"Jari Kempers","image":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/secure.gravatar.com\/avatar\/6433cb297f720dce97e1f2eebf492073b61167c05c8bb6c65a5f95e6315ec034?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6433cb297f720dce97e1f2eebf492073b61167c05c8bb6c65a5f95e6315ec034?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6433cb297f720dce97e1f2eebf492073b61167c05c8bb6c65a5f95e6315ec034?s=96&d=mm&r=g","caption":"Jari Kempers"},"sameAs":["https:\/\/europeanhealtheconomics.com","https:\/\/www.linkedin.com\/in\/jarikempers\/","https:\/\/x.com\/https:\/\/x.com\/EUROHEOR"]}]}},"_links":{"self":[{"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/posts\/100112414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/comments?post=100112414"}],"version-history":[{"count":4,"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/posts\/100112414\/revisions"}],"predecessor-version":[{"id":100137661,"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/posts\/100112414\/revisions\/100137661"}],"wp:attachment":[{"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/media?parent=100112414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/categories?post=100112414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/europeanhealtheconomics.com\/nl\/wp-json\/wp\/v2\/tags?post=100112414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}