{"id":4743,"date":"2021-11-11T14:12:51","date_gmt":"2021-11-11T14:12:51","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=4743"},"modified":"2021-11-11T14:14:29","modified_gmt":"2021-11-11T14:14:29","slug":"solved-vba-textbox-font-color","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/vba-textbox-font-color\/10760.html","title":{"rendered":"Solved VBA Textbox Font Color"},"content":{"rendered":"<p>I have an Excel VBA form that I use for data entry and data retrieval. (People don&#8217;t need to know how to use Excel.) One field in the form compares the current date to a previous date stored in a cell. If it is more than 2 weeks old, I want to see the textbox font in red. I can use conditional formatting to change the font color in the CELL, but not in the userform&#8217;s TEXTBOX. Basically, when the user finds a record with a date requiring attention, I want it to be noticed. There must be some conditional code I can use. Any help is appreciated.<\/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-4743","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\/4743","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=4743"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=4743"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=4743"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=4743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}