Kleine "Besonderheiten" mit VBA -

<!DOCTYPE html> <html dir="ltr" lang="de"> <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1" /> <title>Kleine "Besonderheiten" mit VBA - </title> <link rel="alternate" type="application/atom+xml" title="Feed - " href="/app.php/feed?sid=b5544bb9c84dd7a8483f9b95e88465d9"> <link rel="alternate" type="application/atom+xml" title="Feed - Neue Themen" href="/app.php/feed/topics?sid=b5544bb9c84dd7a8483f9b95e88465d9"> <link rel="alternate" type="application/atom+xml" title="Feed - Forum - Off Topic" href="/app.php/feed/forum/6?sid=b5544bb9c84dd7a8483f9b95e88465d9"> <link rel="alternate" type="application/atom+xml" title="Feed - Thema - Kleine "Besonderheiten" mit VBA" href="/app.php/feed/topic/688?sid=b5544bb9c84dd7a8483f9b95e88465d9"> <link rel="canonical" href="https://www.vbasteleien.de/viewtopic.php?t=688">  <link href="./assets/css/font-awesome.min.css?assets_version=53" rel="stylesheet"> <link href="./styles/prosilver/theme/stylesheet.css?assets_version=53" rel="stylesheet"> <link href="./styles/prosilver/theme/de/stylesheet.css?assets_version=53" rel="stylesheet">  <meta name="description" content="" /> <meta name="keywords" content="" /> <link rel="mask-icon" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/safari-pinned-tab.svg" color="#5bbad5"> <link rel="shortcut icon" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/favicon.ico"> <link rel="apple-touch-icon" sizes="180x180" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/apple-touch-icon.png"> <link rel="icon" type="image/png" sizes="32x32" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/favicon-32x32.png"> <link rel="icon" type="image/png" sizes="16x16" href="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/favicon-16x16.png"> <meta name="msapplication-TileImage" content="https://www.vbasteleien.de/ext/chris1278/metainfo/favicon/ms-icon-144x144.png"> <link rel="manifest" href="https://www.vbasteleien.de/ext/chris1278/metainfo/styles/all/favinfo/site.webmanifest"> <meta name="msapplication-TileColor" content="#da532c"> <meta name="msapplication-config" content="https://www.vbasteleien.de/ext/chris1278/metainfo/styles/all/favinfo/browserconfig.xml"> <meta name="theme-color" content="#ffffff"> <link href="./ext/crizzo/aboutus/styles/prosilver/theme/aboutus.css?assets_version=53" rel="stylesheet" media="screen" /> <link href="./ext/kasimi/postnumbers/styles/prosilver/theme/postnumbers.css?assets_version=53" rel="stylesheet" media="screen" /> <link href="./ext/vse/abbc3/styles/all/theme/abbc3_common.min.css?assets_version=53" rel="stylesheet" media="screen" /> </head> <body id="phpbb" class="nojs notouch section-viewtopic ltr "> <div id="wrap" class="wrap"> <a id="top" class="top-anchor" accesskey="t"></a> <div id="page-header"> <div class="headerbar" role="banner"> <div class="inner"> <div id="site-description" class="site-description"> <a id="logo" class="logo" href="https://VBAsteleien.de" title="Startseite"> <span class="site_logo"></span> </a> <h1></h1> <p>VBAsteln makes the world go around ...</p> <p class="skiplink"><a href="#start_here">Zum Inhalt</a></p> </div> <div id="search-box" class="search-box search-header" role="search"> <form action="./search.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" method="get" id="search"> <fieldset> <input name="keywords" id="keywords" type="search" maxlength="128" title="Suche nach Wörtern" class="inputbox search tiny" size="20" value="" placeholder="Suche…" /> <button class="button button-search" type="submit" title="Suche"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </button> <a href="./search.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" class="button button-search-end" title="Erweiterte Suche"> <i class="icon fa-cog fa-fw" aria-hidden="true"></i><span class="sr-only">Erweiterte Suche</span> </a> <input type="hidden" name="sid" value="b5544bb9c84dd7a8483f9b95e88465d9" /> </fieldset> </form> </div> </div> </div> <div class="navbar" role="navigation"> <div class="inner"> <ul id="nav-main" class="nav-main linklist" role="menubar"> <li id="quick-links" class="quick-links dropdown-container responsive-menu" data-skip-responsive="true"> <a href="#" class="dropdown-trigger"> <i class="icon fa-bars fa-fw" aria-hidden="true"></i><span>Schnellzugriff</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents" role="menu"> <li class="separator"></li> <li> <a href="./search.php?search_id=unanswered&sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-file-o fa-fw icon-gray" aria-hidden="true"></i><span>Unbeantwortete Themen</span> </a> </li> <li> <a href="./search.php?search_id=active_topics&sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-file-o fa-fw icon-blue" aria-hidden="true"></i><span>Aktive Themen</span> </a> </li> <li class="separator"></li> <li> <a href="./search.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span>Suche</span> </a> </li> <li class="separator"></li> <li> <a href="./memberlist.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-group fa-fw" aria-hidden="true"></i><span>Mitglieder</span> </a> </li> <li> <a href="./memberlist.php?mode=team&sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-shield fa-fw" aria-hidden="true"></i><span>Das Team</span> </a> </li> <li class="separator"></li> <li> <a href="/app.php/thankslist?sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-thumbs-o-up fa-fw" aria-hidden="true"></i><span>Liste der Danksagungen</span> </a> </li> </ul> </div> </li> <li data-skip-responsive="true"> <a href="/app.php/help/faq?sid=b5544bb9c84dd7a8483f9b95e88465d9" rel="help" title="Häufig gestellte Fragen" role="menuitem"> <i class="icon fa-question-circle fa-fw" aria-hidden="true"></i><span>FAQ</span> </a> </li> <li class="rightside" data-skip-responsive="true"> <a href="./ucp.php?mode=login&redirect=viewtopic.php%3Fp%3D2210&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Anmelden" accesskey="x" role="menuitem"> <i class="icon fa-power-off fa-fw" aria-hidden="true"></i><span>Anmelden</span> </a> </li> <li class="rightside" data-skip-responsive="true"> <a href="./ucp.php?mode=register&sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-pencil-square-o fa-fw" aria-hidden="true"></i><span>Registrieren</span> </a> </li> </ul> <ul id="nav-breadcrumbs" class="nav-breadcrumbs linklist navlinks" role="menubar"> <li class="breadcrumbs" itemscope itemtype="https://schema.org/BreadcrumbList"> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope><a itemprop="item" href="https://VBAsteleien.de" data-navbar-reference="home"><i class="icon fa-home fa-fw" aria-hidden="true"></i><span itemprop="name">Startseite</span></a><meta itemprop="position" content="1" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope><a itemprop="item" href="./index.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" accesskey="h" data-navbar-reference="index"><span itemprop="name">VBAsteleien.de -Foren-Übersicht-</span></a><meta itemprop="position" content="2" /></span> <span class="crumb" itemtype="https://schema.org/ListItem" itemprop="itemListElement" itemscope data-forum-id="6"><a itemprop="item" href="./viewforum.php?f=6&sid=b5544bb9c84dd7a8483f9b95e88465d9"><span itemprop="name">Off Topic</span></a><meta itemprop="position" content="3" /></span> </li> <li class="rightside responsive-search"> <a href="./search.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Zeigt die erweiterten Suchoptionen an" role="menuitem"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </a> </li> </ul> </div> </div> </div> <a id="start_here" class="anchor"></a> <div id="page-body" class="page-body" role="main"> <h2 class="topic-title"><a href="./viewtopic.php?t=688&sid=b5544bb9c84dd7a8483f9b95e88465d9">Kleine "Besonderheiten" mit VBA</a></h2>  <div style="display: none !important;">- mal was zum ernsthaften Schmunzeln<br /></div> <div class="action-bar bar-top"> <a href="./posting.php?mode=reply&t=688&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="button" title="Antwort erstellen"> <span>Antworten</span> <i class="icon fa-reply fa-fw" aria-hidden="true"></i> </a> <div class="dropdown-container dropdown-button-control topic-tools"> <span title="Themen-Optionen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-wrench fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li> <a href="./memberlist.php?mode=email&t=688&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Thema weiterempfehlen"> <i class="icon fa-envelope-o fa-fw" aria-hidden="true"></i><span>Thema weiterempfehlen</span> </a> </li> <li> <a href="./viewtopic.php?t=688&sid=b5544bb9c84dd7a8483f9b95e88465d9&view=print" title="Druckansicht" accesskey="p"> <i class="icon fa-print fa-fw" aria-hidden="true"></i><span>Druckansicht</span> </a> </li> </ul> </div> </div> <div class="search-box" role="search"> <form method="get" id="topic-search" action="./search.php?sid=b5544bb9c84dd7a8483f9b95e88465d9"> <fieldset> <input class="inputbox search tiny" type="search" name="keywords" id="search_keywords" size="20" placeholder="Thema durchsuchen…" /> <button class="button button-search" type="submit" title="Suche"> <i class="icon fa-search fa-fw" aria-hidden="true"></i><span class="sr-only">Suche</span> </button> <a href="./search.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" class="button button-search-end" title="Erweiterte Suche"> <i class="icon fa-cog fa-fw" aria-hidden="true"></i><span class="sr-only">Erweiterte Suche</span> </a> <input type="hidden" name="t" value="688" /> <input type="hidden" name="sf" value="msgonly" /> <input type="hidden" name="sid" value="b5544bb9c84dd7a8483f9b95e88465d9" /> </fieldset> </form> </div> <div class="pagination"> 3 Beiträge • Seite <strong>1</strong> von <strong>1</strong> </div> </div> <div id="p2205" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile2205"> <dt class="no-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=6135&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">knobbi38</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=6135&sr=posts&sid=b5544bb9c84dd7a8483f9b95e88465d9">32</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 20. Okt 2024, 14:15</dd> <dd class="profile-posts" data-user-give-id="6135"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/6135/true?sid=b5544bb9c84dd7a8483f9b95e88465d9">2 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="6135"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/6135/false?sid=b5544bb9c84dd7a8483f9b95e88465d9">26 Mal</a></dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von knobbi38"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von knobbi38</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="./memberlist.php?mode=email&u=6135&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="E-Mail senden" class="last-cell"> <span class="contact-icon email-icon">E-Mail senden</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content2205"> <h3 class="first"> <a href="./viewtopic.php?p=2205&sid=b5544bb9c84dd7a8483f9b95e88465d9#p2205">Kleine "Besonderheiten" mit VBA</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2205/report?sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2205&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2205" title="Kopiert den Beitragslink in die Zwischenablage">#1</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2205&sid=b5544bb9c84dd7a8483f9b95e88465d9#p2205" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=6135&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">knobbi38</a></strong> » </span><time datetime="2025-03-05T14:17:02+00:00">5. Mär 2025, 15:17</time> </p> <div class="content">Hallo,<br> <br> hier mal etwas zum Ausprobieren, was nicht ganz so offensichtlich ist: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Sub Test_Schleife() Dim i As Long Dim v As Variant Dim avnt(1 To 10) As Variant For i = 1 To 10 avnt(i) = i Next i Debug.Print "i1="; i For i = 1 To 10 If i = 5 Then Exit For Next i Debug.Print "i2="; i For Each v In avnt() ' Next Debug.Print "v1="; v For Each v In avnt() If v = 5 Then Exit For Next Debug.Print "v2="; v End Sub </code></pre></div> Wer erkennt den Unterschied zwischen For-Next und For-Each?<br> <br> Gruß Knobbi38<br> <br> aus einem <a href="https://ms-office-forum.net/forum/microsoft-access-datenbanken/microsoft-access/3176941-if-else-anweisung-funktioniert-nicht-richtig?p=3176953#post3176953" class="postlink">Beitrag</a> von mir in einem anderen Forum</div> <div id='list_thanks2205'> <div class="notice"> <dl> <dt>Folgende Benutzer bedankten sich beim Autor <a href="./memberlist.php?mode=viewprofile&u=6135&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">knobbi38</a> für den Beitrag: </dt> <dd> <span title="16. Mär 2025, 12:45"><a href="./memberlist.php?mode=viewprofile&u=58&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">d'r Bastler</a></span> </dd> </dl> </div> </div> <div id='div_post_reput2205'> </div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2208" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile2208"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="avatar"><img class="avatar" src="./download/file.php?avatar=58_1661782076.jpg" width="70" height="70" alt="Benutzeravatar" /></a> </div> <a href="./memberlist.php?mode=viewprofile&u=58&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">d'r Bastler</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=58&sr=posts&sid=b5544bb9c84dd7a8483f9b95e88465d9">845</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 29. Aug 2022, 13:20</dd> <dd class="profile-posts" data-user-give-id="58"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/58/true?sid=b5544bb9c84dd7a8483f9b95e88465d9">233 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="58"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/58/false?sid=b5544bb9c84dd7a8483f9b95e88465d9">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content2208"> <h3 > <a href="./viewtopic.php?p=2208&sid=b5544bb9c84dd7a8483f9b95e88465d9#p2208">Re: Kleine "Besonderheiten" mit VBA</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2208/report?sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2208&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2208" title="Kopiert den Beitragslink in die Zwischenablage">#2</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2208&sid=b5544bb9c84dd7a8483f9b95e88465d9#p2208" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=58&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">d'r Bastler</a></strong> » </span><time datetime="2025-03-16T11:33:40+00:00">16. Mär 2025, 12:33</time> </p> <div class="content">Moin Knobbi,<br> <br> mein erstes Aha-Erlebnis aus Deinem Code ist auf jeden Fall mal, dass man nicht nur Objekte wie Worksheets, Shapes oder Items per <em class="text-italics">Each</em> durchlaufen kann, sondern sogar einfachste Arrays/Variants - und das ganz ohne aufwändiges Füllen des Datenfeldes. Aber damit willst Du sicher nicht gelangweilt werden.<br> <br> Zweite Idee: Deine Each-Variante liefert nur den Ausnahme-Wert 5, die Next-Version Ausnahme und Iterator + 1.<br> <br> Beides kann je nach Aufgabe sinnvoll/gewünscht sein, wobei die Each-Version einen bestimmten Wert schneller findet.<br> Ich hoffe, wenigstens <em class="text-italics">ungefähr </em>Deine Frage beantwortet zu haben.<br> <br> Nun des Bastlers naive Gegenfrage: Was willst du uns damit sagen? <img class="smilies" src="./images/smilies/icon_rolleyes.gif" width="15" height="17" alt=":roll:" title="Rolling Eyes"> <br> <br> Liebe Grüße</div> <div id='list_thanks2208'> </div> <div id='div_post_reput2208'> </div> <div id="sig2208" class="signature"><span style="font-size:120%;line-height:116%"><strong class="text-strong">d'r Bastler</strong></span> von den VBAsteleien.de<br> <span style="font-size:85%;line-height:116%">Win 10 + Office 2019 & Win11 + Office 2021 + Visio 2019 pro & macOS.X15 + Office2019pro & Android12 & XL365</span></div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div id="p2210" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile2210"> <dt class="no-profile-rank no-avatar"> <div class="avatar-container"> </div> <a href="./memberlist.php?mode=viewprofile&u=6135&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">knobbi38</a> </dt> <dd class="profile-posts"><strong>Beiträge:</strong> <a href="./search.php?author_id=6135&sr=posts&sid=b5544bb9c84dd7a8483f9b95e88465d9">32</a></dd> <dd class="profile-joined"><strong>Registriert:</strong> 20. Okt 2024, 14:15</dd> <dd class="profile-posts" data-user-give-id="6135"><strong>Hat sich bedankt:</strong> <a href="/app.php/thankslist/givens/6135/true?sid=b5544bb9c84dd7a8483f9b95e88465d9">2 Mal</a></dd> <dd class="profile-posts" data-user-receive-id="6135"><strong>Danksagung erhalten:</strong> <a href="/app.php/thankslist/givens/6135/false?sid=b5544bb9c84dd7a8483f9b95e88465d9">26 Mal</a></dd> <dd class="profile-contact"> <strong>Kontaktdaten:</strong> <div class="dropdown-container dropdown-left"> <a href="#" class="dropdown-trigger" title="Kontaktdaten von knobbi38"> <i class="icon fa-commenting-o fa-fw icon-lg" aria-hidden="true"></i><span class="sr-only">Kontaktdaten von knobbi38</span> </a> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents contact-icons"> <div> <a href="./memberlist.php?mode=email&u=6135&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="E-Mail senden" class="last-cell"> <span class="contact-icon email-icon">E-Mail senden</span> </a> </div> </div> </div> </div> </dd> </dl> <div class="postbody"> <div id="post_content2210"> <h3 > <a href="./viewtopic.php?p=2210&sid=b5544bb9c84dd7a8483f9b95e88465d9#p2210">Re: Kleine "Besonderheiten" mit VBA</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/2210/report?sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Diesen Beitrag melden" class="button button-icon-only"> <i class="icon fa-exclamation fa-fw" aria-hidden="true"></i><span class="sr-only">Melden</span> </a> </li> <li> <a href="./posting.php?mode=quote&p=2210&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Mit Zitat antworten" class="button button-icon-only"> <i class="icon fa-quote-left fa-fw" aria-hidden="true"></i><span class="sr-only">Zitieren</span> </a> </li> </ul> <p class="author post-number post-number-phpbb post-number-bold"> <a href="#p2210" title="Kopiert den Beitragslink in die Zwischenablage">#3</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=2210&sid=b5544bb9c84dd7a8483f9b95e88465d9#p2210" title="Beitrag"> <i class="icon fa-file fa-fw icon-lightgray icon-md" aria-hidden="true"></i><span class="sr-only">Beitrag</span> </a> <span class="responsive-hide">von <strong><a href="./memberlist.php?mode=viewprofile&u=6135&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">knobbi38</a></strong> » </span><time datetime="2025-03-16T18:06:29+00:00">16. Mär 2025, 19:06</time> </p> <div class="content">Hallo d'r Bastler,<br> <blockquote class="uncited"><div>Was willst du uns damit sagen?</div></blockquote> Etwas auf die Unterschiede eingehen, bei der Verwendung von einem Iterator und einer Schleifenvariable in eine For-Next Schleife. Der Einfachheit halber wird oft eine Schleifenvariable verwendet, um zu erkennen, ob eine Schleife vorzeitig verlassen oder bis zum Ende durchlaufen wurde. Die Schleifenvariabel in einer For-Next Schleife hat nach Verlassen der Schleife immer einen definierten Wert, wohingegen bei einer For-Each Iteration dieser nicht unbedingt definiert sein muss, sondern z.B. bei Objekten den Wert Nothing annehmen kann. Dieses ist bei einer Prüfung zu beachten und muss ggf. abgefangen werden. <br> <br> Auch wenn es um Performance geht, sollte geprüft werden, welches der beiden Verfahren geeigneter ist - sie kann sich manchmal erheblich unterscheiden.<br> <br> Grüße<br> Knobbi38</div> <div id='list_thanks2210'> <div class="notice"> <dl> <dt>Folgende Benutzer bedankten sich beim Autor <a href="./memberlist.php?mode=viewprofile&u=6135&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">knobbi38</a> für den Beitrag: </dt> <dd> <span title="17. Mär 2025, 08:25"><a href="./memberlist.php?mode=viewprofile&u=58&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="username">d'r Bastler</a></span> </dd> </dl> </div> </div> <div id='div_post_reput2210'> </div> </div> </div> <div class="back2top"> <a href="#top" class="top" title="Nach oben"> <i class="icon fa-chevron-circle-up fa-fw icon-gray" aria-hidden="true"></i> <span class="sr-only">Nach oben</span> </a> </div> </div> </div> <div class="action-bar bar-bottom"> <a href="./posting.php?mode=reply&t=688&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="button" title="Antwort erstellen"> <span>Antworten</span> <i class="icon fa-reply fa-fw" aria-hidden="true"></i> </a> <div class="dropdown-container dropdown-button-control topic-tools"> <span title="Themen-Optionen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-wrench fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li> <a href="./memberlist.php?mode=email&t=688&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Thema weiterempfehlen"> <i class="icon fa-envelope-o fa-fw" aria-hidden="true"></i><span>Thema weiterempfehlen</span> </a> </li> <li> <a href="./viewtopic.php?t=688&sid=b5544bb9c84dd7a8483f9b95e88465d9&view=print" title="Druckansicht" accesskey="p"> <i class="icon fa-print fa-fw" aria-hidden="true"></i><span>Druckansicht</span> </a> </li> </ul> </div> </div> <form method="post" action="./viewtopic.php?t=688&sid=b5544bb9c84dd7a8483f9b95e88465d9"> <div class="dropdown-container dropdown-container-left dropdown-button-control sort-tools"> <span title="Anzeige- und Sortierungs-Einstellungen" class="button button-secondary dropdown-trigger dropdown-select"> <i class="icon fa-sort-amount-asc fa-fw" aria-hidden="true"></i> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown hidden"> <div class="pointer"><div class="pointer-inner"></div></div> <div class="dropdown-contents"> <fieldset class="display-options"> <label>Anzeigen: <select name="st" id="st"><option value="0" selected="selected">Alle Beiträge</option><option value="1">1 Tag</option><option value="7">7 Tage</option><option value="14">2 Wochen</option><option value="30">1 Monat</option><option value="90">3 Monate</option><option value="180">6 Monate</option><option value="365">1 Jahr</option></select></label> <label>Sortiere nach: <select name="sk" id="sk"><option value="a">Autor</option><option value="t" selected="selected">Erstellungsdatum</option><option value="s">Betreff</option></select></label> <label>Richtung: <select name="sd" id="sd"><option value="a" selected="selected">Aufsteigend</option><option value="d">Absteigend</option></select></label> <hr class="dashed" /> <input type="submit" class="button2" name="sort" value="Los" /> </fieldset> </div> </div> </div> </form> <div class="pagination"> 3 Beiträge • Seite <strong>1</strong> von <strong>1</strong> </div> </div> <div class="action-bar actions-jump"> <p class="jumpbox-return"> <a href="./viewforum.php?f=6&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="left-box arrow-left" accesskey="r"> <i class="icon fa-angle-left fa-fw icon-black" aria-hidden="true"></i><span>Zurück zu „Off Topic“</span> </a> </p> <div class="jumpbox dropdown-container dropdown-container-right dropdown-up dropdown-left dropdown-button-control" id="jumpbox"> <span title="Gehe zu" class="button button-secondary dropdown-trigger dropdown-select"> <span>Gehe zu</span> <span class="caret"><i class="icon fa-sort-down fa-fw" aria-hidden="true"></i></span> </span> <div class="dropdown"> <div class="pointer"><div class="pointer-inner"></div></div> <ul class="dropdown-contents"> <li><a href="./viewforum.php?f=1&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-forum-link"> <span> VBAsteleien.de - Herzlich willkommen!</span></a></li> <li><a href="./viewforum.php?f=8&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-forum-link"> <span> Microsoft Access</span></a></li> <li><a href="./viewforum.php?f=3&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-forum-link"> <span> Microsoft Excel</span></a></li> <li><a href="./viewforum.php?f=9&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳   Tutorials</span></a></li> <li><a href="./viewforum.php?f=5&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-forum-link"> <span> Microsoft Outlook</span></a></li> <li><a href="./viewforum.php?f=10&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-forum-link"> <span> Microsoft Powerpoint</span></a></li> <li><a href="./viewforum.php?f=7&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-forum-link"> <span> Microsoft Visio</span></a></li> <li><a href="./viewforum.php?f=11&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-forum-link"> <span> Microsoft Word</span></a></li> <li><a href="./viewforum.php?f=6&sid=b5544bb9c84dd7a8483f9b95e88465d9" class="jumpbox-forum-link"> <span> Off Topic</span></a></li> </ul> </div> </div> </div> <div class="stat-block online-list"> <h3><a href="./viewonline.php?sid=b5544bb9c84dd7a8483f9b95e88465d9">Wer ist online?</a></h3> <p>Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast</p> </div> </div> <div id="page-footer" class="page-footer" role="contentinfo"> <div class="navbar" role="navigation"> <div class="inner"> <ul id="nav-footer" class="nav-footer linklist" role="menubar"> <li class="breadcrumbs"> <span class="crumb"><a href="https://VBAsteleien.de" data-navbar-reference="home"><i class="icon fa-home fa-fw" aria-hidden="true"></i><span>Startseite</span></a></span> <span class="crumb"><a href="./index.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" data-navbar-reference="index"><span>VBAsteleien.de -Foren-Übersicht-</span></a></span> </li> <li class="rightside">Alle Zeiten sind <span title="Europa/Berlin">UTC+01:00</span></li> <li class="rightside"> <a href="./ucp.php?mode=delete_cookies&sid=b5544bb9c84dd7a8483f9b95e88465d9" data-ajax="true" data-refresh="true" role="menuitem"> <i class="icon fa-trash fa-fw" aria-hidden="true"></i><span>Alle Cookies löschen</span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="./memberlist.php?sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Zeigt eine vollständige Liste aller Mitglieder an" role="menuitem"> <i class="icon fa-group fa-fw" aria-hidden="true"></i><span>Mitglieder</span> </a> </li> <li class="rightside" data-last-responsive="true"> <a href="./memberlist.php?mode=team&sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-shield fa-fw" aria-hidden="true"></i><span>Das Team</span> </a> </li> <li class="rightside" data-last-responsive="true"><a href="/app.php/aboutus?sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"><i class="icon fa-info-circle fa-fw" aria-hidden="true"></i><span>Impressum</span></a></li> <li class="rightside" data-last-responsive="true"> <a href="./memberlist.php?mode=contactadmin&sid=b5544bb9c84dd7a8483f9b95e88465d9" role="menuitem"> <i class="icon fa-envelope fa-fw" aria-hidden="true"></i><span>Kontakt</span> </a> </li> </ul> </div> </div> <div class="copyright"> <p class="footer-row"> <span class="footer-copyright">Powered by <a href="https://www.phpbb.com/">phpBB</a>® Forum Software © phpBB Limited</span> </p> <p class="footer-row"> <span class="footer-copyright">Deutsche Übersetzung durch <a href="https://www.phpbb.de/">phpBB.de</a></span> </p> <p class="footer-row" role="menu"> <a class="footer-link" href="./ucp.php?mode=privacy&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Datenschutz" role="menuitem"> <span class="footer-link-text">Datenschutz</span> </a> | <a class="footer-link" href="./ucp.php?mode=terms&sid=b5544bb9c84dd7a8483f9b95e88465d9" title="Nutzungsbedingungen" role="menuitem"> <span class="footer-link-text">Nutzungsbedingungen</span> </a> </p> </div> <div id="darkenwrapper" class="darkenwrapper" data-ajax-error-title="AJAX-Fehler" data-ajax-error-text="Bei der Verarbeitung deiner Anfrage ist ein Fehler aufgetreten." data-ajax-error-text-abort="Der Benutzer hat die Anfrage abgebrochen." data-ajax-error-text-timeout="Bei deiner Anfrage ist eine Zeitüberschreitung aufgetreten. Bitte versuche es erneut." data-ajax-error-text-parsererror="Bei deiner Anfrage ist etwas falsch gelaufen und der Server hat eine ungültige Antwort zurückgegeben."> <div id="darken" class="darken"> </div> </div> <div id="phpbb_alert" class="phpbb_alert" data-l-err="Fehler" data-l-timeout-processing-req="Bei der Anfrage ist eine Zeitüberschreitung aufgetreten."> <a href="#" class="alert_close"> <i class="icon fa-times-circle fa-fw" aria-hidden="true"></i> </a> <h3 class="alert_title"> </h3><p class="alert_text"></p> </div> <div id="phpbb_confirm" class="phpbb_alert"> <a href="#" class="alert_close"> <i class="icon fa-times-circle fa-fw" aria-hidden="true"></i> </a> <div class="alert_text"></div> </div> </div> </div> <div> <a id="bottom" class="anchor" accesskey="z"></a> </div> <script src="./assets/javascript/jquery-3.6.0.min.js?assets_version=53"></script> <script src="./assets/javascript/core.js?assets_version=53"></script> <script src="./ext/kasimi/postnumbers/styles/all/template/postnumbers.js?assets_version=53"></script> <script src="./styles/prosilver/template/forum_fn.js?assets_version=53"></script> <script src="./styles/prosilver/template/ajax.js?assets_version=53"></script> <script src="./ext/vse/abbc3/styles/all/template/js/abbc3.min.js?assets_version=53"></script> <script> var postNumbers = { lang: { copied : 'Kopiert\u0021', copyManually : 'Beitragslink\u0020in\u0020die\u0020Zwischenablage\u003A\u0020Ctrl\/Cmd\u002BC,\u0020Enter' } }; </script> </body> </html>

CINXE.COM

Kleine "Besonderheiten" mit VBA -