{"id":3654,"date":"2023-09-27T16:13:55","date_gmt":"2023-09-27T16:13:55","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/"},"modified":"2023-12-03T13:04:53","modified_gmt":"2023-12-03T13:04:53","slug":"variables-nachrichtenfeld","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/","title":{"rendered":"Wie verwende ich eine variable in einem nachrichtenfeld?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-2449506001\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Sie k\u00f6nnen eine <a href=\"https:\/\/exceladvisor.org\/de\/variablen\/\">Variable<\/a> auch in einem Meldungsfeld verwenden. Nehmen wir an, Sie haben eine Variable, die einen bestimmten Wert in dieser Variablen speichert.<\/p><p> Sie k\u00f6nnen diese Variable nun im <a href=\"https:\/\/exceladvisor.org\/de\/vba-nachrichtenbox\/\">Meldungsfeld<\/a> verwenden, um dem Benutzer den Wert anzuzeigen. Im folgenden Beispiel haben wir ein Makro verwendet, in dem wir die for-Schleife verwendet haben und eine Funktion zum <a href=\"https:\/\/exceladvisor.org\/de\/zufallszahl\/\">Generieren einer Zufallszahl<\/a> haben. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60695\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-variable-messagebox\" width=\"760\" height=\"486\"><\/figure><\/div><p> Wenn Sie <a href=\"https:\/\/exceladvisor.org\/de\/ein-makro-ausfuhren-2\/\">diesen Code ausf\u00fchren<\/a> , f\u00fchrt er eine zehnmalige Schleife aus, generiert dann eine Zufallszahl und speichert diese Zahl in der Variablen. In der folgenden Codezeile haben wir dieselbe Variable verwendet, um den Wert im Meldungsfeld anzuzeigen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-60696\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"161\" height=\"191\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub generateRandomNumber() Dim i As Integer, rNumber As Integer i = 10 For i = 1 To i rNumber = WorksheetFunction.RandBetween(1000, 2000) MsgBox rNumber Next i End Sub<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/vba\/\">Was ist VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Verwandte Tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/globale-variable\/\">Deklarieren Sie eine globale (\u00f6ffentliche) Variable in VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/variabler-bereich\/\">Verwenden Sie in VBA einen Bereich oder eine Zelle als Variable<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/explizite-option-2\/\">Explizite Optionsanweisung in VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/schwach\/\">Dimmen Sie die VBA-Anweisung<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/variablen\/\">VBA-Variablen (Deklaration, Datentypen und Umfang)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3654","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Wie verwende ich eine Variable in einem Nachrichtenfeld?<\/title>\n<meta name=\"description\" content=\"Sie k\u00f6nnen eine Variable auch in einem Meldungsfeld verwenden. Nehmen wir an, Sie haben eine Variable, die\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie verwende ich eine Variable in einem Nachrichtenfeld?\" \/>\n<meta property=\"og:description\" content=\"Sie k\u00f6nnen eine Variable auch in einem Meldungsfeld verwenden. Nehmen wir an, Sie haben eine Variable, die\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:04:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/\",\"name\":\"Wie verwende ich eine Variable in einem Nachrichtenfeld?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\",\"datePublished\":\"2023-09-27T16:13:55+00:00\",\"dateModified\":\"2023-12-03T13:04:53+00:00\",\"description\":\"Sie k\u00f6nnen eine Variable auch in einem Meldungsfeld verwenden. Nehmen wir an, Sie haben eine Variable, die\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich eine variable in einem nachrichtenfeld?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie verwende ich eine Variable in einem Nachrichtenfeld?","description":"Sie k\u00f6nnen eine Variable auch in einem Meldungsfeld verwenden. Nehmen wir an, Sie haben eine Variable, die","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:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich eine Variable in einem Nachrichtenfeld?","og_description":"Sie k\u00f6nnen eine Variable auch in einem Meldungsfeld verwenden. Nehmen wir an, Sie haben eine Variable, die","og_url":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:04:53+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/","url":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/","name":"Wie verwende ich eine Variable in einem Nachrichtenfeld?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png","datePublished":"2023-09-27T16:13:55+00:00","dateModified":"2023-12-03T13:04:53+00:00","description":"Sie k\u00f6nnen eine Variable auch in einem Meldungsfeld verwenden. Nehmen wir an, Sie haben eine Variable, die","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/boite-de-message-variable-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/variables-nachrichtenfeld\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich eine variable in einem nachrichtenfeld?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3654"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3654\/revisions"}],"predecessor-version":[{"id":4361,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3654\/revisions\/4361"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}