{"id":6495,"date":"2016-02-14T22:49:33","date_gmt":"2016-02-14T21:49:33","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=6495"},"modified":"2016-02-14T22:49:33","modified_gmt":"2016-02-14T21:49:33","slug":"vba-et-excel-ecrire-dans-une-cellule","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=6495","title":{"rendered":"VBA et EXCEL : \u00e9crire dans une cellule"},"content":{"rendered":"<p style=\"text-align: justify;\">Le langage VBA est une d\u00e9clinaison du langage <a href=\"http:\/\/www.auditsi.eu\/?p=1665\">BASIC<\/a> con\u00e7u pour interagir avec les applications du <a href=\"http:\/\/www.auditsi.eu\/?p=501\">pack Office<\/a>. La version du VBA adjointe \u00e0 Excel permet d&#8217;interagir avec les feuilles de calcul et notamment d&#8217;\u00e9crire dans ses cellules.<\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.auditsi.eu\/?attachment_id=6499\" rel=\"attachment wp-att-6499\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6499\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/02\/Tableau-Excel.png\" alt=\"Tableau Excel\" width=\"187\" height=\"330\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/02\/Tableau-Excel.png 187w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/02\/Tableau-Excel-170x300.png 170w\" sizes=\"auto, (max-width: 187px) 100vw, 187px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Pour interagir avec les cellules Excel, il faut d\u00e9finir l&#8217;adresse de la cellule (ou de la plage de cellules) concern\u00e9e et la nature du r\u00e9sultat \u00e0 \u00e9crire (formule de calcul ou r\u00e9sultat donn\u00e9 par une formule de calcul).<\/p>\n<p style=\"text-align: justify; padding-left: 30px;\"><em>1. d\u00e9finir l&#8217;adresse de la cellule :<\/em><\/p>\n<ul>\n<li style=\"text-align: justify;\"><em>Cells (ligne, colonne)<\/em> : adresse la cellule identifi\u00e9e par ses num\u00e9ros de ligne et de colonne ;\u00a0exemple avec la cellule A3 :<\/li>\n<\/ul>\n<pre class=\"lang:default decode:true\">.cells(3,1)<\/pre>\n<ul>\n<li><em>Range(adresse cellule)<\/em> : adresse la cellule ou la plage de cellules d\u00e9sign\u00e9e ; exemple avec la cellule A3 puis la plage de cellules de A3 \u00e0 C8 :<\/li>\n<\/ul>\n<pre class=\"lang:default decode:true \">.Range(\"A3)\r\n.Range(\"A3:C8\")<\/pre>\n<p style=\"padding-left: 30px;\">2.\u00a0<em>d\u00e9finir la nature du r\u00e9sultat \u00e0 \u00e9crire :<\/em><\/p>\n<ul>\n<li><em>.Value<\/em> : cette propri\u00e9t\u00e9 envoie le r\u00e9sultat du calcul, soit ici 129 :<\/li>\n<\/ul>\n<pre class=\"lang:default decode:true\">.Value = \"=SUM(B9:B15)\"<\/pre>\n<ul>\n<li><em>.Formula<\/em> : cette propri\u00e9t\u00e9, ainsi que les suivantes,\u00a0envoie la formule de calcul r\u00e9dig\u00e9e en anglais dans la cellule Excel d\u00e9sign\u00e9e,<\/li>\n<li style=\"text-align: justify;\"><em>.FormulaLocal<\/em> : cette propri\u00e9t\u00e9 r\u00e9alise la m\u00eame fonction que .Formula mais \u00e0 partir d&#8217;une formule de calcul r\u00e9dig\u00e9e en fran\u00e7ais,<\/li>\n<li style=\"text-align: justify;\"><em>.FormulaR1C1<\/em> : cette propri\u00e9t\u00e9 \u00e9quivaut \u00e0 .Formula mais les cellule sont r\u00e9f\u00e9renc\u00e9e au format R1C1 au lieu de A1,<\/li>\n<li style=\"text-align: justify;\"><em>.FormulaLocalR1C1<\/em> : cette propri\u00e9t\u00e9 \u00e9quivaut \u00e0 FormulaR1C1 mais \u00e0 partir d&#8217;une formule de calcul r\u00e9dig\u00e9e en fran\u00e7ais,<\/li>\n<li style=\"text-align: justify;\"><em>.FormulaArray<\/em> : cette propri\u00e9t\u00e9 permet de lancer des calculs matriciels (elle \u00e9quivaut \u00e0 la combinaison des touches Ctrl+Maj+Entr\u00e9e lorsque l&#8217;on saisit une formule matricielle dans une feuille de calcul Excel).<\/li>\n<\/ul>\n<p>Exemples :<\/p>\n<pre class=\"lang:default decode:true \">.Formula = \"=SUM(B9:B15)\"\r\n.FormulaLocal = \"=SOMME(B9:B15)\"\r\n.FormulaR1C1 = \"=SUM(R9C2:R15C2)\"\r\n<\/pre>\n<p>Chacune de ces formules stockera l&#8217;expression &#8220;=SOMME(B9:B15)&#8221; avec la version fran\u00e7aise d&#8217;Excel.<\/p>\n<p>Et pour finir, le code source associant l&#8217;adresse de la cellule\u00a0\u00e0 modifier \u00e0 la nature du r\u00e9sultat \u00e0 obtenir se r\u00e9dige ainsi :<\/p>\n<pre class=\"lang:default decode:true\">Range(\"A1\").Formula = \"=SUM(B9:B15)\"<\/pre>\n<p>Approfondir le sujet :\u00a0<a title=\"Programmer en VBA\" href=\"http:\/\/www.auditsi.eu\/?cat=1569\">Programmer en VBA<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"VBA%20et%20EXCEL%20%3A%20%C3%A9crire%20dans%20une%20cellule\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Le langage VBA est une d\u00e9clinaison du langage BASIC con\u00e7u pour interagir avec les applications du pack Office. La version du VBA adjointe \u00e0 Excel permet d&#8217;interagir avec les feuilles de calcul et notamment d&#8217;\u00e9crire dans ses cellules. Pour interagir avec les cellules Excel, il faut d\u00e9finir l&#8217;adresse de la cellule (ou de la plage &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=6495\" class=\"more-link\">Continue reading &lsquo;VBA et EXCEL : \u00e9crire dans une cellule&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"VBA%20et%20EXCEL%20%3A%20%C3%A9crire%20dans%20une%20cellule\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48,1569,215],"tags":[1565,668,370,1712,1711,1647,618,839,249,1713,1633,1144,1561,263,261,1641],"class_list":["post-6495","post","type-post","status-publish","format-standard","hentry","category-excel","category-programmer-en-vba","category-vba","tag-formula","tag-formulaarray","tag-formulalocal","tag-formulalocalr1c1","tag-formular1c1","tag-basic","tag-calcul-matriciel","tag-calculs","tag-cells","tag-cellule","tag-excel","tag-formule-de-calcul","tag-plage-de-cellules","tag-range","tag-value","tag-vba"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6495"}],"version-history":[{"count":3,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6495\/revisions"}],"predecessor-version":[{"id":6502,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6495\/revisions\/6502"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}