CINXE.COM
theSpamGate -
<!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>theSpamGate - </title> <link rel="alternate" type="application/atom+xml" title="Feed - " href="/app.php/feed?sid=d18db6003c029eb2f128f605d37b569e"> <link rel="alternate" type="application/atom+xml" title="Feed - Neue Themen" href="/app.php/feed/topics?sid=d18db6003c029eb2f128f605d37b569e"> <link rel="alternate" type="application/atom+xml" title="Feed - Forum - Microsoft Excel" href="/app.php/feed/forum/3?sid=d18db6003c029eb2f128f605d37b569e"> <link rel="alternate" type="application/atom+xml" title="Feed - Thema - theSpamGate" href="/app.php/feed/topic/619?sid=d18db6003c029eb2f128f605d37b569e"> <link rel="canonical" href="https://www.vbasteleien.de/viewtopic.php?t=619"> <!-- phpBB style name: prosilver Based on style: prosilver (this is the default phpBB3 style) Original author: Tom Beddard ( http://www.subBlue.com/ ) Modified by: --> <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"> <!--[if lte IE 9]> <link href="./styles/prosilver/theme/tweaks.css?assets_version=53" rel="stylesheet"> <![endif]--> <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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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="d18db6003c029eb2f128f605d37b569e" /> </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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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%3Ft%3D619&sid=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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="3"><a itemprop="item" href="./viewforum.php?f=3&sid=d18db6003c029eb2f128f605d37b569e"><span itemprop="name">Microsoft Excel</span></a><meta itemprop="position" content="3" /></span> </li> <li class="rightside responsive-search"> <a href="./search.php?sid=d18db6003c029eb2f128f605d37b569e" 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=619&sid=d18db6003c029eb2f128f605d37b569e">theSpamGate</a></h2> <!-- NOTE: remove the style="display: none" when you want to have the forum description on the topic body --> <div style="display: none !important;">.. das wohl mächtigste Werkzeug in Bill Gates' Büro-Sippe. Ob reine Formeln, PowerQuery oder VBA. Hier bleiben kaum Wünsche unerfüllt.<br /></div> <div class="action-bar bar-top"> <a href="./posting.php?mode=reply&t=619&sid=d18db6003c029eb2f128f605d37b569e" 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=619&sid=d18db6003c029eb2f128f605d37b569e" 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=619&sid=d18db6003c029eb2f128f605d37b569e&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=d18db6003c029eb2f128f605d37b569e"> <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=d18db6003c029eb2f128f605d37b569e" 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="619" /> <input type="hidden" name="sf" value="msgonly" /> <input type="hidden" name="sid" value="d18db6003c029eb2f128f605d37b569e" /> </fieldset> </form> </div> <div class="pagination"> 3 Beiträge • Seite <strong>1</strong> von <strong>1</strong> </div> </div> <div id="p1712" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1712"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e">841</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=d18db6003c029eb2f128f605d37b569e">229 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=d18db6003c029eb2f128f605d37b569e">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content1712"> <h3 class="first"> <a href="./viewtopic.php?p=1712&sid=d18db6003c029eb2f128f605d37b569e#p1712">theSpamGate</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/1712/report?sid=d18db6003c029eb2f128f605d37b569e" 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=1712&sid=d18db6003c029eb2f128f605d37b569e" 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="#p1712" title="Kopiert den Beitragslink in die Zwischenablage">#1</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=1712&sid=d18db6003c029eb2f128f605d37b569e#p1712" 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=d18db6003c029eb2f128f605d37b569e" class="username">d'r Bastler</a></strong> » </span><time datetime="2024-09-07T12:33:07+00:00">7. Sep 2024, 14:33</time> </p> <div class="content">Moin allerseits,<br> wer hier nicht nur die XL-Snippets abstaubt (you're welcome <img class="smilies" src="./images/smilies/icon_e_biggrin.gif" width="15" height="17" alt=":D" title="Very Happy">), hat vielleicht mitgelesen, dass die Administration des Forums durchaus mit Aufwand verbunden ist. Bis Anfang September war es für mich tägliche Übung, Anmeldeversuche von zumeist russischen Mädchen-, Waffen- und Drogenhändlern abzuwehren. Im Schnitt der letzten anderthalb Jahre knapp drei / Tag. <br> <br> Seit September ist Schluss damit. Denn mir wurde eine Extension für die Board-Software empfohlen, die sich sehr bewährt: <em class="text-italics">Sorted Captcha</em> vom phpBB-Coder Derky. Ihm vielen lieben Dank dafür!! Die Hürde für Spammer besteht darin, dass Aussagen des täglichen Lebens richtig zugeordnet werden müssen. So'n bisschen wie beim ARD-<em class="text-italics">Wissens</em>quiz <em class="text-italics">Meister des Allttags</em>.<br> <br> Nun habe ich das Dingen in XL/VBA nachgebaut und etwas erweitert. In Derkys Version stehen fünf Aussagen alle in der Box WAHR, und die falschen müssen aussortiert werden. In meiner stehen alle Aussagen in einer Aussage-Box und müssen dann WAHR/FALSCH zugeordnet werden. Wobei die Positionen der beiden Zielboxen zufällig wechseln, wie auch die Auswahl der Aussagen. Damit hoffe ich Robot-sicher zu sein.<br> <br> Was muss man zum Testen tun? Man baut sich eine Tabelle mit 30 Aussagen in Spalte A und setzt in Spalte B <em class="text-italics">true </em>oder <em class="text-italics">false </em>dazu. Für dieses Sheet nimmt man noch folgenden Code: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True usfSpamGate.Show End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) Columns.AutoFit End Sub</code></pre></div> Etwas versteckt in Spalte Z1 / Z2 gehören noch die Texte <blockquote class="uncited"><div>Benutzername<br> Statement auswählen und per Doppelklick True/False zuordnen</div></blockquote> Dann importiert man die unten angehängte Userform, und schon kann's losgehen.<br> <div class="inline-attachment"><!-- ia0 -->usfSpamGate.frx<!-- ia0 --></div> <div class="inline-attachment"><!-- ia1 -->usfSpamGate.frm<!-- ia1 --></div> Möchte man mehrere Aussagenkataloge (z.B. in verschiedenen Sprachen) erstellen, kopiert man einfach das erste Sheet (mit dem Code und Spalte Z) und legt mit neuen Aussagen los. Ein Doppelklick in eine beliebige Zelle startet die UserForm.<br> <br> Viel Spaß damit und noch mal DANK AN DERKY<br> lg</div> <div class="rules">Du hast keine ausreichende Berechtigung, um die Dateianhänge dieses Beitrags anzusehen.</div> <div id='list_thanks1712'> </div> <div id='div_post_reput1712'> </div> <div id="sig1712" 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="p1713" class="post has-profile bg1"> <div class="inner"> <dl class="postprofile" id="profile1713"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e">841</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=d18db6003c029eb2f128f605d37b569e">229 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=d18db6003c029eb2f128f605d37b569e">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content1713"> <h3 > <a href="./viewtopic.php?p=1713&sid=d18db6003c029eb2f128f605d37b569e#p1713">Re: theSpamGate</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/1713/report?sid=d18db6003c029eb2f128f605d37b569e" 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=1713&sid=d18db6003c029eb2f128f605d37b569e" 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="#p1713" title="Kopiert den Beitragslink in die Zwischenablage">#2</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=1713&sid=d18db6003c029eb2f128f605d37b569e#p1713" 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=d18db6003c029eb2f128f605d37b569e" class="username">d'r Bastler</a></strong> » </span><time datetime="2024-09-07T14:03:13+00:00">7. Sep 2024, 16:03</time> </p> <div class="content">Und hier ausnahmsweise mal eine komplette Mappe in niederländisch und deutsch:<br> <div class="inline-attachment"><!-- ia0 -->SpamGate.xlsb<!-- ia0 --></div></div> <div class="rules">Du hast keine ausreichende Berechtigung, um die Dateianhänge dieses Beitrags anzusehen.</div> <div id='list_thanks1713'> </div> <div id='div_post_reput1713'> </div> <div id="sig1713" 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="p1714" class="post has-profile bg2"> <div class="inner"> <dl class="postprofile" id="profile1714"> <dt class="no-profile-rank has-avatar"> <div class="avatar-container"> <a href="./memberlist.php?mode=viewprofile&u=58&sid=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e">841</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=d18db6003c029eb2f128f605d37b569e">229 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=d18db6003c029eb2f128f605d37b569e">123 Mal</a></dd> </dl> <div class="postbody"> <div id="post_content1714"> <h3 > <a href="./viewtopic.php?p=1714&sid=d18db6003c029eb2f128f605d37b569e#p1714">Re: theSpamGate</a> </h3> <ul class="post-buttons"> <li> <a href="/app.php/post/1714/report?sid=d18db6003c029eb2f128f605d37b569e" 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=1714&sid=d18db6003c029eb2f128f605d37b569e" 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="#p1714" title="Kopiert den Beitragslink in die Zwischenablage">#3</a> </p> <p class="author"> <a class="unread" href="./viewtopic.php?p=1714&sid=d18db6003c029eb2f128f605d37b569e#p1714" 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=d18db6003c029eb2f128f605d37b569e" class="username">d'r Bastler</a></strong> » </span><time datetime="2024-09-07T14:34:52+00:00">7. Sep 2024, 16:34</time> </p> <div class="content">Nachtrag: <div class="codebox"><p>Code: <a href="#" onclick="selectCode(this); return false;">Alles auswählen</a></p><pre><code> Cells(r, 9) = "ok"</code></pre></div> in Zeile 201 des Codes ergänzt (nach WELCOME) markiert die erfolgreichen Nutzer.</div> <div id='list_thanks1714'> </div> <div id='div_post_reput1714'> </div> <div id="sig1714" 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 class="action-bar bar-bottom"> <a href="./posting.php?mode=reply&t=619&sid=d18db6003c029eb2f128f605d37b569e" 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=619&sid=d18db6003c029eb2f128f605d37b569e" 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=619&sid=d18db6003c029eb2f128f605d37b569e&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=619&sid=d18db6003c029eb2f128f605d37b569e"> <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=3&sid=d18db6003c029eb2f128f605d37b569e" 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 „Microsoft Excel“</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=d18db6003c029eb2f128f605d37b569e" class="jumpbox-forum-link"> <span> VBAsteleien.de - Herzlich willkommen!</span></a></li> <li><a href="./viewforum.php?f=8&sid=d18db6003c029eb2f128f605d37b569e" class="jumpbox-forum-link"> <span> Microsoft Access</span></a></li> <li><a href="./viewforum.php?f=3&sid=d18db6003c029eb2f128f605d37b569e" class="jumpbox-forum-link"> <span> Microsoft Excel</span></a></li> <li><a href="./viewforum.php?f=9&sid=d18db6003c029eb2f128f605d37b569e" class="jumpbox-sub-link"><span class="spacer"></span> <span>↳ Tutorials</span></a></li> <li><a href="./viewforum.php?f=5&sid=d18db6003c029eb2f128f605d37b569e" class="jumpbox-forum-link"> <span> Microsoft Outlook</span></a></li> <li><a href="./viewforum.php?f=10&sid=d18db6003c029eb2f128f605d37b569e" class="jumpbox-forum-link"> <span> Microsoft Powerpoint</span></a></li> <li><a href="./viewforum.php?f=7&sid=d18db6003c029eb2f128f605d37b569e" class="jumpbox-forum-link"> <span> Microsoft Visio</span></a></li> <li><a href="./viewforum.php?f=11&sid=d18db6003c029eb2f128f605d37b569e" class="jumpbox-forum-link"> <span> Microsoft Word</span></a></li> <li><a href="./viewforum.php?f=6&sid=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e">Wer ist online?</a></h3> <p>Mitglieder in diesem Forum: <span style="color: #9E8DA7;" class="username-coloured">Ahrefs [Bot]</span> und 5 Gäste</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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" 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=d18db6003c029eb2f128f605d37b569e" title="Datenschutz" role="menuitem"> <span class="footer-link-text">Datenschutz</span> </a> | <a class="footer-link" href="./ucp.php?mode=terms&sid=d18db6003c029eb2f128f605d37b569e" 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> <img class="sr-only" aria-hidden="true" src="/app.php/cron/cron.task.text_reparser.poll_option?sid=d18db6003c029eb2f128f605d37b569e" width="1" height="1" alt=""> </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>