{"id":3713,"date":"2021-11-04T21:23:52","date_gmt":"2021-11-04T21:23:52","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=3713"},"modified":"2021-11-04T21:24:24","modified_gmt":"2021-11-04T21:24:24","slug":"vlookup-on-a-userform-with-textboxes","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/vlookup-on-a-userform-with-textboxes\/11180.html","title":{"rendered":"Vlookup On a Userform With Textboxes"},"content":{"rendered":"<p>Hi! I am trying to make a userform where I<br \/>\nenter a 6-digit code in TextBox1 and as soon<br \/>\nas I enter the last digit, I want its<br \/>\ncorresponding Item Name to be displayed in<br \/>\nTextBox2. I already have an Excel sheet that<br \/>\ncan be used for a Vlookup function but I do not<br \/>\nknow how to apply it as a Visual Basic code in<br \/>\nthe userform. How do I go about this?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":11},"question-category":[53],"question_tags":[],"class_list":["post-3713","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/3713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=3713"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=3713"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=3713"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=3713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}