{"id":9400,"date":"2018-07-30T13:28:44","date_gmt":"2018-07-30T05:28:44","guid":{"rendered":"http:\/\/www.jdcui.com\/?p=9400"},"modified":"2026-02-17T08:41:46","modified_gmt":"2026-02-17T00:41:46","slug":"vba%e7%bc%96%e7%a8%8b%e5%bc%80%e5%8f%91-vba%e4%bd%bf%e7%94%a8textframe2%e8%ae%be%e7%bd%ae%e5%9d%90%e6%a0%87%e8%bd%b4%e5%b1%9e%e6%80%a7%e5%87%ba%e9%94%99","status":"publish","type":"post","link":"http:\/\/www.jdcui.com\/?p=9400","title":{"rendered":"[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519"},"content":{"rendered":"<p>\u7528VBA\u5f00\u53d1EXCEL\uff0c\u4e3a\u4fee\u6539\u5750\u6807\u8f74\u523b\u5ea6\u7ebf\u5b57\u4f53\u7684\u5927\u5199\uff0c\u901a\u8fc7\u5f55\u5236\u5b8f\u770b\u5230\u5982\u4e0b\u4ee3\u7801\uff1a<\/p>\n<p><code>ActiveChart.Axes(xlValue).Select <\/code><\/p>\n<p><code>With Selection.Format.TextFrame2.TextRange.Font <\/code><\/p>\n<p><code>\u00a0 .Size = 12<\/code><\/p>\n<p><code>\u00a0 .Bold = True <\/code><\/p>\n<p><code>End With<\/code><\/p>\n<p>\u53ef\u4ee5\u4ece \u5b8f \u4e2d\u770b\u89c1\uff0c\u4ee3\u7801\u662f\u901a\u8fc7 <code>TextFrame2\u00a0<\/code>\u5c5e\u6027\u5bf9\u523b\u5ea6\u7ebf\u59ff\u6001\u8fdb\u884c\u63a7\u5236\u7684\u3002<\/p>\n<p>\u4f46\u5c06\u4e0a\u8ff0\u4ee3\u7801\u5728\u7a0b\u5e8f\u4e2d\u7f16\u8bd1\uff0c\u5219\u53d1\u73b0\u62a5\u9519\uff0c\u63d0\u793a\u00a0 <code>TextFrame2\u00a0<\/code>\u65e0\u6cd5\u8bc6\u522b\uff0c\u4e0d\u5b58\u5728\u3002<\/p>\n<p>\u4e0d\u77e5\u9053\u662fBug\u8fd8\u662f\u4ec0\u4e48\uff0c\u6700\u540e\u901a\u8fc7<code> TickLabels<\/code> \u5c5e\u6027\u89e3\u51b3\u3002<\/p>\n<hr \/>\n<p><center><strong><div  class=\"thumbs-rating-container\" id=\"thumbs-rating-9400\" data-content-id=\"9400\"><button class=\"thumbs-rating-up thumbs-rating-voted\" onclick=\"thumbs_rating_vote(9400, 1);\">Vote Up +10<\/button> <button class=\"thumbs-rating-down thumbs-rating-voted\" onclick=\"thumbs_rating_vote(9400, 2);\">Vote Down -3<\/button><span class=\"thumbs-rating-already-voted\">You already voted!<\/span><\/div><\/strong><\/center><\/p>\n<ul style=\"list-style-type: square;\">\n<li style=\"text-align: left;\"><strong>\u5fae\u4fe1\u516c\u4f17\u53f7\u00a0(\u00a0<span style=\"color: #0000ff;\">Wechat\u00a0Subscription<\/span>)<\/strong><\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.jdcui.com\/wp-content\/uploads\/2017\/01\/QRCODE.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3636\" src=\"http:\/\/www.jdcui.com\/wp-content\/uploads\/2017\/01\/QRCODE.jpg\" alt=\"WeChat_QRCode\" width=\"250\" height=\"255\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><strong>\u6b22\u8fce\u5173\u6ce8\u00a0\u201c<span style=\"color: #ff00ff;\">\u7ed3\u6784\u4e4b\u65c5<\/span>\u201d\u00a0\u5fae\u4fe1\u516c\u4f17\u53f7<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7528VBA\u5f00\u53d1EXCEL\uff0c\u4e3a\u4fee\u6539\u5750\u6807\u8f74\u523b\u5ea6\u7ebf\u5b57\u4f53\u7684\u5927\u5199\uff0c\u901a\u8fc7\u5f55\u5236\u5b8f\u770b\u5230\u5982\u4e0b\u4ee3\u7801\uff1a ActiveChart.Axes(xlValue).Select With Selection.Format.TextFrame2.TextRange.Font \u00a0 .Size = 12 \u00a0 .Bold = True End With \u53ef\u4ee5\u4ece \u5b8f \u4e2d\u770b\u89c1\uff0c\u4ee3\u7801\u662f\u901a\u8fc7 TextFrame2\u00a0\u5c5e\u6027\u5bf9\u523b\u5ea6\u7ebf\u59ff\u6001\u8fdb\u884c\u63a7\u5236\u7684\u3002 \u4f46\u5c06\u4e0a\u8ff0\u4ee3\u7801\u5728\u7a0b\u5e8f\u4e2d\u7f16\u8bd1\uff0c\u5219\u53d1\u73b0\u62a5\u9519\uff0c\u63d0\u793a\u00a0 TextFrame2\u00a0\u65e0\u6cd5\u8bc6\u522b\uff0c\u4e0d\u5b58\u5728\u3002 \u4e0d\u77e5\u9053\u662fBug\u8fd8\u662f\u4ec0\u4e48\uff0c\u6700\u540e\u901a\u8fc7 TickLabels \u5c5e\u6027\u89e3\u51b3\u3002 \u5fae\u4fe1\u516c\u4f17\u53f7\u00a0(\u00a0Wechat\u00a0Subscription) \u6b22\u8fce\u5173\u6ce8\u00a0\u201c\u7ed3\u6784\u4e4b\u65c5\u201d\u00a0\u5fae\u4fe1\u516c\u4f17\u53f7<\/p>\n","protected":false},"author":1,"featured_media":9413,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[1391,1447,1448,253,1047,999],"class_list":["post-9400","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programming","tag-excel","tag-textframe2","tag-vba","tag-253","tag-1047","tag-999"],"aioseo_notices":[],"views":2793,"_links":{"self":[{"href":"http:\/\/www.jdcui.com\/index.php?rest_route=\/wp\/v2\/posts\/9400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.jdcui.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jdcui.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jdcui.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jdcui.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9400"}],"version-history":[{"count":0,"href":"http:\/\/www.jdcui.com\/index.php?rest_route=\/wp\/v2\/posts\/9400\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.jdcui.com\/index.php?rest_route=\/wp\/v2\/media\/9413"}],"wp:attachment":[{"href":"http:\/\/www.jdcui.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jdcui.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9400"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jdcui.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}