{"id":3586,"date":"2022-02-18T10:52:56","date_gmt":"2022-02-18T09:52:56","guid":{"rendered":"https:\/\/controlc.fr\/?post_type=lp_course&p=3586"},"modified":"2025-12-05T16:46:03","modified_gmt":"2025-12-05T15:46:03","slug":"excel-les-macros-et-sensibilisation-vba","status":"publish","type":"lp_course","link":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/","title":{"rendered":"EXCEL LES MACROS ET SENSIBILISATION VBA"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u00a0Programme<\/h2>

\u00a0<\/p>

Introduction et g\u00e9n\u00e9ralit\u00e9s<\/strong><\/em>
Int\u00e9r\u00eats de Visual Basic Application dans Excel
Quand utiliser des macros<\/p>

Enregistrement des macros<\/em><\/strong>
Utiliser l\u2019enregistreur de macros
Modifier une macro enregistr\u00e9e
Affecter une macro \u00e0 un bouton, \u00e0 un ic\u00f4ne ou \u00e0 un ruban
Ex\u00e9cuter les macros<\/p>

Programmation avec VBA<\/strong><\/em>
Pr\u00e9sentation de Visual Basic Editeur
Int\u00e9grer la notion de module, proc\u00e9dure et les g\u00e9rer
Int\u00e9grer la notion d\u2019objet, propri\u00e9t\u00e9s, m\u00e9thodes et les utiliser
Les instructions et op\u00e9rateurs
Les structures simples de conditions (If.End If)
Saisir et afficher des informations (InputBox, MsgBox)
Int\u00e9grer la notion de variables
Cr\u00e9er des macros usuelles: impression, tris, filtres\u2026<\/p>

Aide et Gestion des erreurs de programmation<\/strong><\/em>
Aide VBA
Comprendre et g\u00e9rer les messages
d\u2019erreurs lors de l\u2019interruption de la macro
Ex\u00e9cution pas \u00e0 pas pour comprendre les erreurs<\/p><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLa fiche formation<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tNos tarifs<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLe planning<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

\u00a0Programme \u00a0 Introduction et g\u00e9n\u00e9ralit\u00e9sInt\u00e9r\u00eats de Visual Basic Application dans ExcelQuand utiliser des macros Enregistrement des macrosUtiliser l\u2019enregistreur de macrosModifier une macro enregistr\u00e9eAffecter une macro \u00e0 un bouton, \u00e0 un ic\u00f4ne ou \u00e0 un rubanEx\u00e9cuter les macros Programmation avec VBAPr\u00e9sentation de Visual Basic EditeurInt\u00e9grer la notion de module, proc\u00e9dure et…<\/p>\n","protected":false},"author":6,"featured_media":6001,"comment_status":"closed","ping_status":"closed","template":"","course_category":[10,36],"course_tag":[],"class_list":["post-3586","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-bureautique","course_category-tableur-excel-et-calc","course"],"yoast_head":"\nEXCEL LES MACROS ET SENSIBILISATION VBA -<\/title>\n<meta name=\"description\" content=\"Programme de la formation d'une journ\u00e9e sur les macros d'Excel et la sensibilisation \u00e0 la programmation VBA.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXCEL LES MACROS ET SENSIBILISATION VBA -\" \/>\n<meta property=\"og:description\" content=\"Programme de la formation d'une journ\u00e9e sur les macros d'Excel et la sensibilisation \u00e0 la programmation VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-05T15:46:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@controlcmelun\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/\",\"url\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/\",\"name\":\"EXCEL LES MACROS ET SENSIBILISATION VBA -\",\"isPartOf\":{\"@id\":\"https:\/\/controlc.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"datePublished\":\"2022-02-18T09:52:56+00:00\",\"dateModified\":\"2025-12-05T15:46:03+00:00\",\"description\":\"Programme de la formation d'une journ\u00e9e sur les macros d'Excel et la sensibilisation \u00e0 la programmation VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#primaryimage\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"width\":200,\"height\":200,\"caption\":\"Microsoft Excel 2019 ic\u00f4ne par Icons8\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/controlc.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cours\",\"item\":\"https:\/\/controlc.fr\/index.php\/cours-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EXCEL LES MACROS ET SENSIBILISATION VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/controlc.fr\/#website\",\"url\":\"https:\/\/controlc.fr\/\",\"name\":\"Controlc.fr\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/controlc.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/controlc.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/controlc.fr\/#organization\",\"name\":\"Control^C\",\"url\":\"https:\/\/controlc.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"width\":427,\"height\":100,\"caption\":\"Control^C\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/controlcmelun\",\"https:\/\/www.linkedin.com\/company\/8009384\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EXCEL LES MACROS ET SENSIBILISATION VBA -","description":"Programme de la formation d'une journ\u00e9e sur les macros d'Excel et la sensibilisation \u00e0 la programmation VBA.","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:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/","og_locale":"fr_FR","og_type":"article","og_title":"EXCEL LES MACROS ET SENSIBILISATION VBA -","og_description":"Programme de la formation d'une journ\u00e9e sur les macros d'Excel et la sensibilisation \u00e0 la programmation VBA.","og_url":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/","article_modified_time":"2025-12-05T15:46:03+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@controlcmelun","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/","url":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/","name":"EXCEL LES MACROS ET SENSIBILISATION VBA -","isPartOf":{"@id":"https:\/\/controlc.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#primaryimage"},"image":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","datePublished":"2022-02-18T09:52:56+00:00","dateModified":"2025-12-05T15:46:03+00:00","description":"Programme de la formation d'une journ\u00e9e sur les macros d'Excel et la sensibilisation \u00e0 la programmation VBA.","breadcrumb":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#primaryimage","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","width":200,"height":200,"caption":"Microsoft Excel 2019 ic\u00f4ne par Icons8"},{"@type":"BreadcrumbList","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-les-macros-et-sensibilisation-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/controlc.fr\/"},{"@type":"ListItem","position":2,"name":"Cours","item":"https:\/\/controlc.fr\/index.php\/cours-2\/"},{"@type":"ListItem","position":3,"name":"EXCEL LES MACROS ET SENSIBILISATION VBA"}]},{"@type":"WebSite","@id":"https:\/\/controlc.fr\/#website","url":"https:\/\/controlc.fr\/","name":"Controlc.fr","description":"","publisher":{"@id":"https:\/\/controlc.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/controlc.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/controlc.fr\/#organization","name":"Control^C","url":"https:\/\/controlc.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","width":427,"height":100,"caption":"Control^C"},"image":{"@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/controlcmelun","https:\/\/www.linkedin.com\/company\/8009384"]}]}},"_links":{"self":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/3586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=3586"}],"version-history":[{"count":35,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/3586\/revisions"}],"predecessor-version":[{"id":6482,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/3586\/revisions\/6482"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media\/6001"}],"wp:attachment":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=3586"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_category?post=3586"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_tag?post=3586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}