{"id":12166,"date":"2012-11-19T14:57:02","date_gmt":"2012-11-19T14:57:02","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2580"},"modified":"2012-11-19T14:57:02","modified_gmt":"2012-11-19T14:57:02","slug":"input-message-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/","title":{"rendered":"How to display Input message on selecting a cell in Excel"},"content":{"rendered":"<p>Dear Friends,<\/p>\n<p><\/p>\n<p>In this article I am going to explain you.. How you can display a message as soon as on selecting a cell. Most importantly here you need not write any VBA code to do so. When I say it is an input message, it is not a message box or input message box. It is like comment in excel cell, as soon as you select the cell comment will be displayed, but actually it is not a comment. Then what exactly it is?? Why don&#8217;t we try this?<br \/>\n<\/p>\n<p>This input message is setup from the <strong>Data<\/strong> Tab where we set the dropdown list in excel Cell or Cell Range.<\/p>\n<h2>How to set up an Input Message on cell or Cell Range<\/h2>\n<p><font color=\"AB0101\">Step 1.<\/font>Select the Cell or Cell Range where you want to display the message.<br \/>\n<br \/>\n<div id=\"attachment_2581\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-2581\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png\" alt=\"How to add Input Message in Excel\" title=\"How to add Input Message in Excel - 1\" width=\"700\" height=\"359\" class=\"size-full wp-image-2581\" \/><p id=\"caption-attachment-2581\" class=\"wp-caption-text\">How to add Input Message in Excel<\/p><\/div><br \/>\n<\/p>\n<p><font color=\"AB0101\">Step 2.<\/font>Go to Data Tab and click on Data Validation as shown in the below image as shown in the below image.<br \/>\n<br \/>\n<div id=\"attachment_2582\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-2582\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-1.png\" alt=\"How to add Input Message in Excel Cell \" title=\"How to add Input Message in Excel Cell - 2\" width=\"700\" height=\"359\" class=\"size-full wp-image-2582\" \/><p id=\"caption-attachment-2582\" class=\"wp-caption-text\">How to add Input Message in Excel Cell - 2<\/p><\/div><br \/>\n<\/br><br \/>\n<font color=\"AB0101\">Step 3.<\/font>Enter the Title and Body of the message you want to be displayed and click on Ok as shown in the below picture.<br \/>\n<br \/>\n<div id=\"attachment_2583\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-2583\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-3.png\" alt=\"How to add an Input Message in Excel Cell \" title=\"How to add an Input Message in Excel Cell - 3\" width=\"600\" height=\"478\" class=\"size-full wp-image-2583\" \/><p id=\"caption-attachment-2583\" class=\"wp-caption-text\">How to add an Input Message in Excel Cell - 3<\/p><\/div><br \/>\n<br \/>\n<font color=\"AB0101\">Step 4.<\/font>You are done now. In the selected range as soon as you select any of the cell your input message will be displayed. As soon as you again select any other cell, message will automatically disappear.<br \/>\n<br \/>\n<div id=\"attachment_2584\" style=\"width: 581px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-2584\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-4.png\" alt=\"How to add an Input Message in Excel \" title=\"How to add an Input Message in Excel - 4\" width=\"571\" height=\"386\" class=\"size-full wp-image-2584\" \/><p id=\"caption-attachment-2584\" class=\"wp-caption-text\">How to add an Input Message in Excel - 4<\/p><\/div><\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Dear Friends, In this article I am going to explain you.. How you can display a message as soon as on selecting a cell. Most importantly here you need not write any VBA code to do so. When I say it is an input message, it is not a message box or input message box. [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1673],"tags":[],"class_list":["post-12166","post","type-post","status-publish","format-standard","hentry","category-excel-functions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to display Input message on selecting a cell in Excel - Let&#039;s excel in Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to display Input message on selecting a cell in Excel\" \/>\n<meta property=\"og:description\" content=\"Dear Friends, In this article I am going to explain you.. How you can display a message as soon as on selecting a cell. Most importantly here you need not write any VBA code to do so. When I say it is an input message, it is not a message box or input message box. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-19T14:57:02+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"How to display Input message on selecting a cell in Excel\",\"datePublished\":\"2012-11-19T14:57:02+00:00\",\"dateModified\":\"2012-11-19T14:57:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/\"},\"wordCount\":299,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png\",\"articleSection\":[\"Excel Functions\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/\",\"name\":\"How to display Input message on selecting a cell in Excel - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png\",\"datePublished\":\"2012-11-19T14:57:02+00:00\",\"dateModified\":\"2012-11-19T14:57:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Functions\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-functions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to display Input message on selecting a cell in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to display Input message on selecting a cell in Excel - Let&#039;s excel in Excel","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:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to display Input message on selecting a cell in Excel","og_description":"Dear Friends, In this article I am going to explain you.. How you can display a message as soon as on selecting a cell. Most importantly here you need not write any VBA code to do so. When I say it is an input message, it is not a message box or input message box. [&hellip;]","og_url":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-11-19T14:57:02+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"How to display Input message on selecting a cell in Excel","datePublished":"2012-11-19T14:57:02+00:00","dateModified":"2012-11-19T14:57:02+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/"},"wordCount":299,"commentCount":2,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png","articleSection":["Excel Functions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/","url":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/","name":"How to display Input message on selecting a cell in Excel - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png","datePublished":"2012-11-19T14:57:02+00:00","dateModified":"2012-11-19T14:57:02+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/11\/Input-Message-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/11\/input-message-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Functions","item":"https:\/\/vmlogger.com\/excel\/excel-functions\/"},{"@type":"ListItem","position":3,"name":"How to display Input message on selecting a cell in Excel"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12166"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12166"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12166\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}