{"id":10283,"date":"2022-09-23T03:48:50","date_gmt":"2022-09-22T22:18:50","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/"},"modified":"2022-09-23T03:48:50","modified_gmt":"2022-09-22T22:18:50","slug":"solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/","title":{"rendered":"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-47843657\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"47843657\" data-parentid=\"47839514\" 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>So her is a new Solution. You have to declare 3 Public Variables in the UserForm1 Modul. So you can give them Values while the USerForm is open and Find the Naxt Values when you click multiple Times on the Search Button.<\/p>\n<pre><code>'Public Variables \n    Public bolFirstSearch As Boolean\n    Public rng As Excel.Range\n    Public cellFound  As Excel.Range\n\nPrivate Sub ComboBox1_Change()\n    bolFirstSearch = False\nEnd Sub\n\nPrivate Sub CommandButton1_Click()\nDim strFindWhat As String\nDim intRowCB As Integer\n\nOn Error GoTo ErrorMessage\nIf UserForm1.bolFirstSearch = False Then\n\n    strFindWhat = TextBox1.Text\n    intRowCB = Cells.Find(What:=ComboBox1.value, After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Column\n    Set rng = Columns(intRowCB)\n    rng.Select\n        Set cellFound = rng.Find(What:=strFindWhat, After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)\n        cellFound.Select\nElse\n\n    Set cellFound = rng.FindNext(cellFound)\n    cellFound.Select\nEnd If\nUserForm1.bolFirstSearch = True\nExit Sub\nErrorMessage:\n\n MsgBox (\"The data you are searching for does not exist\")\nEnd Sub\n\nPrivate Sub UserForm_Initialize()\n    ComboBox1.List = Application.Transpose(Sheet1.Range(\"A1:D1\").Value)\n    bolFirstSearch = False\nEnd Sub\n\nPrivate Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)\n    bolFirstSearch = False\nEnd Sub\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">6<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet? <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] So her is a new Solution. You have to declare 3 Public Variables in the UserForm1 Modul. So you can give them Values while the USerForm is open and Find the Naxt Values when you click multiple Times on the Search Button. &#8216;Public Variables Public bolFirstSearch As Boolean Public rng As Excel.Range Public cellFound &#8230; <a title=\"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/\" aria-label=\"More on [Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?\">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":[1678,400,1241,401],"class_list":["post-10283","post","type-post","status-publish","format-standard","hentry","category-solved","tag-combobox","tag-excel","tag-textbox","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet? - 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-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet? - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] So her is a new Solution. You have to declare 3 Public Variables in the UserForm1 Modul. So you can give them Values while the USerForm is open and Find the Naxt Values when you click multiple Times on the Search Button. &#039;Public Variables Public bolFirstSearch As Boolean Public rng As Excel.Range Public cellFound ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-22T22:18:50+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-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?\",\"datePublished\":\"2022-09-22T22:18:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/\"},\"wordCount\":91,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"combobox\",\"excel\",\"textbox\",\"vba\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/\",\"name\":\"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet? - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-22T22:18:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?\"}]},{\"@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=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet? - 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-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet? - JassWeb","og_description":"[ad_1] So her is a new Solution. You have to declare 3 Public Variables in the UserForm1 Modul. So you can give them Values while the USerForm is open and Find the Naxt Values when you click multiple Times on the Search Button. 'Public Variables Public bolFirstSearch As Boolean Public rng As Excel.Range Public cellFound ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/","og_site_name":"JassWeb","article_published_time":"2022-09-22T22:18:50+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-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?","datePublished":"2022-09-22T22:18:50+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/"},"wordCount":91,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["combobox","excel","textbox","vba"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/","url":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/","name":"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet? - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-22T22:18:50+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-do-i-use-a-combobox-and-textbox-on-a-userform-in-vba-to-search-and-find-data-on-the-active-excel-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?"}]},{"@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=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","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\/10283","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=10283"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10283\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=10283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=10283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=10283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}