{"id":8919,"date":"2021-11-30T09:49:50","date_gmt":"2021-11-30T09:49:50","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=8919"},"modified":"2021-11-30T09:50:46","modified_gmt":"2021-11-30T09:50:46","slug":"excel-2010-check-box-form-control-appear-disappear","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-2010-check-box-form-control-appeardisappear\/18298.html","title":{"rendered":"Excel 2010 | Check Box (Form Control) Appear\/Disappear"},"content":{"rendered":"<p>Hi,<\/p>\n<p>Is it possible to have a Check Box (Form Control) appear\/disappear in a cell by selecting a value from a dropdown menu? For example: I have my dropdown menu in cell b2. Based on certain dropdown values, I would like different Check Boxes to appear in B4-B6.<\/p>\n<p>Meaning, if B2=\u201dApple\u201d, I need B4 to have a check box to enable \u201cGranny Smith\u201d, B5 to have a check box to enable \u201cPink Lady\u201d, and B6 to have a check box to enable \u201cFuji\u201d. But if B2=\u201dGrape\u201d, I need B4 to have a check box to enable \u201cGreen\u201d and B5 to have a check box to enable \u201cPurple\u201d.<\/p>\n<p>I am open to using other types of form controls or coding to make this happen\u2013it\u2019s just that my knowledge in that area is slim.<\/p>\n<p>Appreciate the assistance!<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":1},"question-category":[53],"question_tags":[],"class_list":["post-8919","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\/8919","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=8919"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=8919"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=8919"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=8919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}