{"id":14955,"date":"2021-12-17T13:58:28","date_gmt":"2021-12-17T13:58:28","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=14955"},"modified":"2021-12-17T13:58:54","modified_gmt":"2021-12-17T13:58:54","slug":"solved-drop-down-list-in-excel-with-user-input-and-autofill","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/drop-down-list-in-excel-with-user-input-and-autofill\/16265.html","title":{"rendered":"Solved Drop Down List In Excel With User Input And Autofill"},"content":{"rendered":"<p>Hi,<\/p>\n<p>I apologize in advance if this is confusing and it may even not be possible but I do appreciate any help!<\/p>\n<p>I am making a screening log for patients for clinical trials. I have made several drop down lists for the exclusion criteria for the studies using the validation option. I am missing two things, however.<\/p>\n<p>1) One of the options from the drop down list is Other where I would like to have a text box pop up for the user to input a value. I&#8217;ve seen a code for this before:<\/p>\n<p>Private Sub Worksheet_Change(ByVal Target As Range)<br \/>\n&#8216;If Drop Down choice is Other, get value<br \/>\n&#8216;from user and place it in A1<br \/>\nIf Target.Address = &#8220;$A$1&#8221; Then<br \/>\nIf Target = &#8220;Other&#8221; Then<br \/>\notherVal = Application.InputBox(&#8220;Enter Other Value&#8221;)<br \/>\nIf otherVal = False Then Exit Sub<br \/>\nRange(&#8220;A1&#8221;).Value = otherVal<br \/>\nEnd If<br \/>\nEnd If<br \/>\nEnd Sub<\/p>\n<p>The problem is that my input range needs to be across various columns and infinite rows and I don&#8217;t know how to do that. (I apologize if this is basic stuff&#8230;)<\/p>\n<p>2) We screen all patients but some don&#8217;t have the disease they need for trials &#8211; this would automatically exclude them. Would it be possible to have a column that asks if they have the disease (Yes or No) and then if No automatically populates the other columns as Non-disease but if Yes then allows for the drop down lists I have (which have the exclusion criteria)?<\/p>\n<p>Thanks in advance for any help, I&#8217;ve been googling and trying things on my own but I don&#8217;t seem to be getting very far&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":34},"question-category":[53],"question_tags":[],"class_list":["post-14955","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\/14955","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=14955"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=14955"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=14955"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=14955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}