{"id":6412,"date":"2025-06-27T15:24:25","date_gmt":"2025-06-27T13:24:25","guid":{"rendered":"https:\/\/controlc.fr\/?post_type=lp_course&p=6412"},"modified":"2025-12-02T17:08:10","modified_gmt":"2025-12-02T16:08:10","slug":"excel-vba-perfectionnement","status":"publish","type":"lp_course","link":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/","title":{"rendered":"EXCEL VBA PERFECTIONNEMENT"},"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

Programme<\/h2>

Rappels des bases de la programmation VBA<\/strong><\/p>

Les commandes (Instructions, Fonctions)<\/p>

Les objets (M\u00e9thode, Propri\u00e9t\u00e9s, \u00c9v\u00e8nements)<\/p>

Les Variables et les Constantes<\/p>

Les Conditions (If<\/em> et Select Case<\/em>)<\/p>

Les Boucles (For Next<\/em> et Do While<\/em>)<\/p>

Proc\u00e9dures et Fonctions<\/strong><\/p>

Les Fonctions personnalis\u00e9es<\/p>

La cr\u00e9ation de macros compl\u00e9mentaires<\/p>

La port\u00e9e Public ou Priv\u00e9 des Sub<\/em> et Function<\/em><\/p>

Le passage de param\u00e8tres<\/p>

Proc\u00e9dures \u00c9v\u00e8nementielles<\/strong><\/p>

Sur le classeur<\/p>

Sur les feuilles<\/p>

Sur Excel<\/p>

D\u00e9bogage et gestion des erreurs<\/strong><\/p>

Mise en place d’un gestionnaire d’erreur<\/p>

Ex\u00e9cution pas \u00e0 pas<\/p>

Bo\u00eetes de dialogue avanc\u00e9es<\/strong><\/p>

Rappel sur\u00a0 InputBox<\/em> et Msgbox<\/em><\/p>

Les bo\u00eetes de dialogues int\u00e9gr\u00e9es<\/p>

Conception de formulaires \u00e9labor\u00e9s (UserForms<\/em>)<\/p>

Gestion de fichiers<\/strong><\/p>

Parcourir les dossiers et fichiers<\/p>

Ajout, modification, suppression de donn\u00e9es dans les fichiers<\/p>

Automation<\/strong><\/p>

\u00c9change avec Word et\/ou Access<\/p>

La fonction SendKeys<\/em><\/p>

\"lien<\/a><\/p>

Moyens techniques mis \u00e0 disposition<\/strong>
Supports d\u2019animation p\u00e9dagogique utilis\u00e9s en vid\u00e9oprojection. 1 PC\/stagiaire \u00e9quip\u00e9 du(es) logiciel(s) pr\u00e9vu(s), connexion Wifi, imprimante multifonctions.
Installations dans notre centre de formation : salles de formation \u00e9quip\u00e9es de tables, chaises, mur clair pour la projection, paperboard et\/ou tableau blanc ou num\u00e9rique interactif.
En cas de formation intra-entreprise, des installations
\u00e9quivalentes doivent \u00eatre mises \u00e0 disposition par l\u2019employeur des stagiaires<\/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":"

Programme Rappels des bases de la programmation VBA Les commandes (Instructions, Fonctions) Les objets (M\u00e9thode, Propri\u00e9t\u00e9s, \u00c9v\u00e8nements) Les Variables et les Constantes Les Conditions (If et Select Case) Les Boucles (For Next et Do While) Proc\u00e9dures et Fonctions Les Fonctions personnalis\u00e9es La cr\u00e9ation de macros compl\u00e9mentaires La port\u00e9e Public ou…<\/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-6412","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-bureautique","course_category-tableur-excel-et-calc","course"],"yoast_head":"\nEXCEL VBA PERFECTIONNEMENT -<\/title>\n<meta name=\"description\" content=\"Programme de la formation perfectionnement en programmation VBA Excel afin d'automatiser les t\u00e2ches r\u00e9p\u00e9titives par la cr\u00e9ation de macros.\" \/>\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-vba-perfectionnement\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"formation Excel VBA initiation Control C Melun CPF organisme Qualiopi\" \/>\n<meta property=\"og:description\" content=\"formation Excel VBA initiation 3 jours Control C Melun CPF organisme Qualiopi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-02T16:08:10+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=\"2 minutes\" \/>\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-vba-perfectionnement\/\",\"url\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/\",\"name\":\"EXCEL VBA PERFECTIONNEMENT -\",\"isPartOf\":{\"@id\":\"https:\/\/controlc.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"datePublished\":\"2025-06-27T13:24:25+00:00\",\"dateModified\":\"2025-12-02T16:08:10+00:00\",\"description\":\"Programme de la formation perfectionnement en programmation VBA Excel afin d'automatiser les t\u00e2ches r\u00e9p\u00e9titives par la cr\u00e9ation de macros.\",\"breadcrumb\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/#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-vba-perfectionnement\/#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 VBA PERFECTIONNEMENT\"}]},{\"@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 VBA PERFECTIONNEMENT -","description":"Programme de la formation perfectionnement en programmation VBA Excel afin d'automatiser les t\u00e2ches r\u00e9p\u00e9titives par la cr\u00e9ation de macros.","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-vba-perfectionnement\/","og_locale":"fr_FR","og_type":"article","og_title":"formation Excel VBA initiation Control C Melun CPF organisme Qualiopi","og_description":"formation Excel VBA initiation 3 jours Control C Melun CPF organisme Qualiopi","og_url":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/","article_modified_time":"2025-12-02T16:08:10+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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/","url":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/","name":"EXCEL VBA PERFECTIONNEMENT -","isPartOf":{"@id":"https:\/\/controlc.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/#primaryimage"},"image":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/#primaryimage"},"thumbnailUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","datePublished":"2025-06-27T13:24:25+00:00","dateModified":"2025-12-02T16:08:10+00:00","description":"Programme de la formation perfectionnement en programmation VBA Excel afin d'automatiser les t\u00e2ches r\u00e9p\u00e9titives par la cr\u00e9ation de macros.","breadcrumb":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-perfectionnement\/#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-vba-perfectionnement\/#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 VBA PERFECTIONNEMENT"}]},{"@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\/6412","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=6412"}],"version-history":[{"count":17,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/6412\/revisions"}],"predecessor-version":[{"id":6446,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/6412\/revisions\/6446"}],"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=6412"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_category?post=6412"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_tag?post=6412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}