{"id":22998,"date":"2022-11-23T01:47:41","date_gmt":"2022-11-22T20:17:41","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/"},"modified":"2022-11-23T01:47:41","modified_gmt":"2022-11-22T20:17:41","slug":"solved-define-an-input-suggestion-with-vba-in-excel","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/","title":{"rendered":"[Solved] define an input suggestion with vba in excel"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-34494683\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"34494683\" data-parentid=\"34476424\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>You could you a simple userform to select and parse data selection into the row you clicked.<\/p>\n<p>First use an Event when you click in the column you want the reminder to pop up in. In this case I choose &#8220;D&#8221;.<\/p>\n<pre><code>Private Sub Worksheet_Change(ByVal Target As Range)\n    Dim arr\n    If Not Intersect(Target, Range(\"D:D\")) Is Nothing Then\n      Application.EnableEvents = 0\n          UserForm1.Show\n          Target = a\n      Application.EnableEvents = 1\n    End If\nEnd Sub\n<\/code><\/pre>\n<p>Then load the user form with your reminder data and select the reminder data you need from a userform combobox.<\/p>\n<pre><code>Private Sub UserForm_Initialize()\n  Dim arr\n    arr = Array(\"Unit1\", \"Unit2\", \"Unit3\", \"Unit4\", \"Unit5\", \"Unit6\", _\n                     \"Unit7\", \"Unit8\", \"Unit9\", \"Unit10\", \"Unit11\", \"Unit12\", _\n                        \"Unit13\", \"Unit14\", \"Unit15\", \"Unit16\", \"Unit17\", \"Unit18\", _\n                          \"Unit19\", \"Unit20\")\n        Me.ComboBox1.List = arr\nEnd Sub\nPrivate Sub ComboBox1_Change()\n     a = ComboBox1.Value\n     Unload Me\nEnd Sub\n<\/code><\/pre>\n<p>And you will need to put a public variable in a standard module to store the data you want pasted in your sheet.<\/p>\n<pre><code>Public a As String\n<\/code><\/pre>\n<p>Be sure to change any control names to suit you.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved define an input suggestion with vba in excel <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] You could you a simple userform to select and parse data selection into the row you clicked. First use an Event when you click in the column you want the reminder to pop up in. In this case I choose &#8220;D&#8221;. Private Sub Worksheet_Change(ByVal Target As Range) Dim arr If Not Intersect(Target, Range(&#8220;D:D&#8221;)) Is &#8230; <a title=\"[Solved] define an input suggestion with vba in excel\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/\" aria-label=\"More on [Solved] define an input suggestion with vba in excel\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[400,401],"class_list":["post-22998","post","type-post","status-publish","format-standard","hentry","category-solved","tag-excel","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] define an input suggestion with vba in excel - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] define an input suggestion with vba in excel - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You could you a simple userform to select and parse data selection into the row you clicked. First use an Event when you click in the column you want the reminder to pop up in. In this case I choose &#8220;D&#8221;. Private Sub Worksheet_Change(ByVal Target As Range) Dim arr If Not Intersect(Target, Range(&quot;D:D&quot;)) Is ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-22T20:17:41+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] define an input suggestion with vba in excel\",\"datePublished\":\"2022-11-22T20:17:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/\"},\"wordCount\":114,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"excel\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/\",\"name\":\"[Solved] define an input suggestion with vba in excel - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-22T20:17:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] define an input suggestion with vba in excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] define an input suggestion with vba in excel - JassWeb","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:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] define an input suggestion with vba in excel - JassWeb","og_description":"[ad_1] You could you a simple userform to select and parse data selection into the row you clicked. First use an Event when you click in the column you want the reminder to pop up in. In this case I choose &#8220;D&#8221;. Private Sub Worksheet_Change(ByVal Target As Range) Dim arr If Not Intersect(Target, Range(\"D:D\")) Is ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/","og_site_name":"JassWeb","article_published_time":"2022-11-22T20:17:41+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] define an input suggestion with vba in excel","datePublished":"2022-11-22T20:17:41+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/"},"wordCount":114,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["excel","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/","url":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/","name":"[Solved] define an input suggestion with vba in excel - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-22T20:17:41+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-define-an-input-suggestion-with-vba-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] define an input suggestion with vba in excel"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/22998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=22998"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/22998\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=22998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=22998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=22998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}