{"id":59,"date":"2025-06-12T21:59:09","date_gmt":"2025-06-12T21:59:09","guid":{"rendered":"https:\/\/loufab.alwaysdata.net\/blogaccess\/?p=59"},"modified":"2025-06-12T21:59:09","modified_gmt":"2025-06-12T21:59:09","slug":"vba-deselection-zone-de-liste","status":"publish","type":"post","link":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/2025\/06\/12\/vba-deselection-zone-de-liste\/","title":{"rendered":"VBA : D\u00e9s\u00e9lection zone de liste"},"content":{"rendered":"\n<p>Lorsque vous&nbsp;utilisez une&nbsp;zone&nbsp;de liste&nbsp;sans s\u00e9lection multiple, il peut arriver d&rsquo;avoir besoin de d\u00e9s\u00e9lectionner la ligne. Inutile de vous acharner sur la ligne s\u00e9lectionn\u00e9e avec votre souris, elle restera en surbrillance.<\/p>\n\n\n\n<p>Je vous livre ici ma m\u00e9thode pour&nbsp;enlever la&nbsp;s\u00e9lection&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Dim itSel As Integer \n\nPrivate Sub Form_Open(Cancel As Integer) \n   'initialise \u00e0 -1 pour ne pas perturber la premi\u00e8re s\u00e9lection \n   itSel = -1 \nEnd Sub \n\nPrivate Sub Liste_Click() \n   'la selection est identique \u00e0 la pr\u00e9c\u00e9dent \n   If Me.Liste.ListIndex = itSel Then \n      Me.Liste.ListIndex = -1 \n      'on d\u00e9selectionne itSel = -1 \n   Else \n      'on fixe le choix pour la prochaine comparaison \n      itSel = Me.Liste.ListIndex \n   End If \nEnd Sub<\/code><\/pre>\n\n\n\n<p>La liste se nomme Liste. On d\u00e9clare une variable globale au&nbsp; formulaire, que l&rsquo;on nomme itSel, elle permettra de conserver le pr\u00e9c\u00e9dent choix op\u00e9r\u00e9, soit un entier positif pour une s\u00e9lection et -1 pour la d\u00e9-s\u00e9lection.<\/p>\n\n\n\n<p>Sur l&rsquo;ouverture du formulaire on consid\u00e8re que rien n&rsquo;est s\u00e9lectionn\u00e9 et on attribue la valeur -1 \u00e0 <strong>itSel<\/strong>. Lorsqu&rsquo;on clique sur la zone de liste, on v\u00e9rifie&nbsp;si le clic correspond \u00e0 la s\u00e9lection en cours au moyen de la propri\u00e9t\u00e9 <strong>ListIndex<\/strong>.<\/p>\n\n\n\n<p>Cette propri\u00e9t\u00e9 retourne un&nbsp;entier&nbsp;de 0 \u00e0 x ou x est le dernier item de la&nbsp;liste.&nbsp;Lorsque qu&rsquo;on attribue une valeur \u00e0 ListIndex l&rsquo;item correspond est s\u00e9lectionn\u00e9, par contre si l&rsquo;on met -1 aucune ligne n&rsquo;est s\u00e9lectionn\u00e9e.<\/p>\n\n\n\n<p>Bonne utilisation !<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lorsque vous&nbsp;utilisez une&nbsp;zone&nbsp;de liste&nbsp;sans s\u00e9lection multiple, il peut arriver d&rsquo;avoir besoin de d\u00e9s\u00e9lectionner la ligne. Inutile de vous acharner sur la ligne s\u00e9lectionn\u00e9e avec votre souris, elle restera en surbrillance. Je vous livre ici ma m\u00e9thode pour&nbsp;enlever la&nbsp;s\u00e9lection&nbsp;: La liste &hellip; <a href=\"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/2025\/06\/12\/vba-deselection-zone-de-liste\/\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,6],"tags":[11,7],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-access","category-code-vba","tag-access","tag-code-vba"],"_links":{"self":[{"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":1,"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"predecessor-version":[{"id":60,"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions\/60"}],"wp:attachment":[{"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/loufab.alwaysdata.net\/blogaccess\/index.php\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}