{"id":6265,"date":"2025-06-09T17:07:14","date_gmt":"2025-06-09T15:07:14","guid":{"rendered":"https:\/\/controlc.fr\/?post_type=lp_course&p=6265"},"modified":"2025-12-02T17:08:54","modified_gmt":"2025-12-02T16:08:54","slug":"excel-vba-initiation","status":"publish","type":"lp_course","link":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/","title":{"rendered":"EXCEL VBA INITIATION"},"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>

Cr\u00e9ation de macro fonctions<\/span><\/b><\/span><\/p>

\u00a0<\/span>Introduction Visual Basic<\/span><\/b><\/span><\/p>

Principes de base de la programmation VBA (Saisie<\/span><\/p>

du code, Structuration du code, Commentaires, Appels de proc\u00e9dures, etc)<\/span><\/p>

\u00a0<\/span>Macros par enregistrement<\/span><\/b><\/span><\/p>

\u00a0<\/span>Langage Visual Basic<\/span><\/b><\/span><\/p>

Objet<\/span><\/p>

M\u00e9thode<\/span><\/p>

Propri\u00e9t\u00e9<\/span><\/p>

Structures de contr\u00f4le<\/span><\/p>

Fen\u00eatre ex\u00e9cution<\/span><\/p>

\u00a0<\/span>Bo\u00eetes de dialogue pr\u00e9d\u00e9finies<\/span><\/b><\/span><\/p>

Msgbox et Inputbox<\/span><\/p>

\u00a0<\/span>Exemples de macros<\/span><\/b><\/span><\/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 Cr\u00e9ation de macro fonctions \u00a0Introduction Visual Basic Principes de base de la programmation VBA (Saisie du code, Structuration du code, Commentaires, Appels de proc\u00e9dures, etc) \u00a0Macros par enregistrement \u00a0Langage Visual Basic Objet M\u00e9thode Propri\u00e9t\u00e9 Structures de contr\u00f4le Fen\u00eatre ex\u00e9cution \u00a0Bo\u00eetes de dialogue pr\u00e9d\u00e9finies Msgbox et Inputbox \u00a0Exemples de macros…<\/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-6265","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 INITIATION -<\/title>\n<meta name=\"description\" content=\"Programme de la formation sur la programmation VBA dans Excel afin de 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-initiation\/\" \/>\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-initiation\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-02T16:08:54+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-vba-initiation\/\",\"url\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/\",\"name\":\"EXCEL VBA INITIATION -\",\"isPartOf\":{\"@id\":\"https:\/\/controlc.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png\",\"datePublished\":\"2025-06-09T15:07:14+00:00\",\"dateModified\":\"2025-12-02T16:08:54+00:00\",\"description\":\"Programme de la formation sur la programmation VBA dans Excel afin de d'automatiser les t\u00e2ches r\u00e9p\u00e9titives par la cr\u00e9ation de macros.\",\"breadcrumb\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/#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-initiation\/#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 INITIATION\"}]},{\"@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 INITIATION -","description":"Programme de la formation sur la programmation VBA dans Excel afin de 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-initiation\/","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-initiation\/","article_modified_time":"2025-12-02T16:08:54+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-vba-initiation\/","url":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/","name":"EXCEL VBA INITIATION -","isPartOf":{"@id":"https:\/\/controlc.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/#primaryimage"},"image":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/#primaryimage"},"thumbnailUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-microsoft-excel-2019-200.png","datePublished":"2025-06-09T15:07:14+00:00","dateModified":"2025-12-02T16:08:54+00:00","description":"Programme de la formation sur la programmation VBA dans Excel afin de d'automatiser les t\u00e2ches r\u00e9p\u00e9titives par la cr\u00e9ation de macros.","breadcrumb":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/index.php\/courses\/excel-vba-initiation\/#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-initiation\/#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 INITIATION"}]},{"@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\/6265","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=6265"}],"version-history":[{"count":13,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/6265\/revisions"}],"predecessor-version":[{"id":6449,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/6265\/revisions\/6449"}],"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=6265"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_category?post=6265"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_tag?post=6265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}