{"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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"[VBA][\u7f16\u7a0b][\u5f00\u53d1][\u7b14\u8bb0] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519\u3002\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 .Size = 12 .Bold = True End With \u53ef\u4ee5\u4ece \u5b8f \u4e2d\u770b\u89c1\uff0c\u4ee3\u7801\u662f\u901a\u8fc7 TextFrame2 \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 TextFrame2 \u65e0\u6cd5\u8bc6\u522b\uff0c\u4e0d\u5b58\u5728\u3002\u4e0d\u77e5\u9053\u662fBug\u8fd8\u662f\u4ec0\u4e48\uff0c\u6700\u540e\u901a\u8fc7 TickLabel \u5c5e\u6027\u89e3\u51b3\u3002\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"CJD\"\/>\n\t<meta name=\"keywords\" content=\"excel,textframe2,vba,\u4e8c\u6b21\u5f00\u53d1,\u5f00\u53d1,\u7f16\u7a0b\" \/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.jdcui.com\/?p=9400\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#article\",\"name\":\"[VBA][\\u7f16\\u7a0b] VBA\\u4f7f\\u7528\\u201cTextFrame2\\u201d\\u8bbe\\u7f6e\\u5750\\u6807\\u8f74\\u5c5e\\u6027\\u51fa\\u9519 | \\u5d14\\u6d4e\\u4e1c\\u7684\\u535a\\u5ba2 - www.jdcui.com\",\"headline\":\"[VBA][\\u7f16\\u7a0b] VBA\\u4f7f\\u7528\\u201cTextFrame2\\u201d\\u8bbe\\u7f6e\\u5750\\u6807\\u8f74\\u5c5e\\u6027\\u51fa\\u9519\",\"author\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.jdcui.com\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/VBAFeaturedPicture.gif\",\"width\":352,\"height\":173},\"datePublished\":\"2018-07-30T13:28:44+08:00\",\"dateModified\":\"2026-02-17T08:41:46+08:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#webpage\"},\"articleSection\":\"Programming [\\u7f16\\u7a0b], Excel, TextFrame2, VBA, \\u4e8c\\u6b21\\u5f00\\u53d1, \\u5f00\\u53d1, \\u7f16\\u7a0b\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.jdcui.com#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.jdcui.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?cat=21#listItem\",\"name\":\"Programming [\\u7f16\\u7a0b]\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?cat=21#listItem\",\"position\":2,\"name\":\"Programming [\\u7f16\\u7a0b]\",\"item\":\"http:\\\/\\\/www.jdcui.com\\\/?cat=21\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#listItem\",\"name\":\"[VBA][\\u7f16\\u7a0b] VBA\\u4f7f\\u7528\\u201cTextFrame2\\u201d\\u8bbe\\u7f6e\\u5750\\u6807\\u8f74\\u5c5e\\u6027\\u51fa\\u9519\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.jdcui.com#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#listItem\",\"position\":3,\"name\":\"[VBA][\\u7f16\\u7a0b] VBA\\u4f7f\\u7528\\u201cTextFrame2\\u201d\\u8bbe\\u7f6e\\u5750\\u6807\\u8f74\\u5c5e\\u6027\\u51fa\\u9519\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?cat=21#listItem\",\"name\":\"Programming [\\u7f16\\u7a0b]\"}}]},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/#organization\",\"name\":\"\\u5d14\\u6d4e\\u4e1c\\u7684\\u535a\\u5ba2 - www.jdcui.com\",\"description\":\"\\u5b9e\\u5e72\\u3001\\u5b9e\\u8df5\\u3001\\u79ef\\u7d2f\\u3001\\u601d\\u8003\\u3001\\u521b\\u65b0\\uff01 Tag: \\u7ed3\\u6784\\u5de5\\u7a0b\\u535a\\u58eb \\u7ed3\\u6784\\u5de5\\u7a0b\\u5e08 \\u4f2a\\u7a0b\\u5e8f\\u5458 \\u7ed3\\u6784\\u6297\\u9707 \\u5730\\u9707\\u5de5\\u7a0b \\u8d85\\u9650\\u8bbe\\u8ba1 \\u8f6f\\u4ef6\\u5b9a\\u5236 \\u73af\\u8bc4\\u51cf\\u632f \\u632f\\u52a8\\u63a7\\u5236 \\u51cf\\u9694\\u9707 \\u65bd\\u5de5\\u8fc7\\u7a0b\\u6a21\\u62df \\u5c0f\\u54c1\\u94a2\\u7ed3\\u6784 \\u6709\\u9650\\u5143\\u7814\\u53d1 \\u53c2\\u6570\\u5316\\u8bbe\\u8ba1 \\u5927\\u9707\\u5f39\\u5851\\u6027\",\"url\":\"http:\\\/\\\/www.jdcui.com\\\/\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?author=1#author\",\"url\":\"http:\\\/\\\/www.jdcui.com\\\/?author=1\",\"name\":\"CJD\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e2fdb66ee1ab31c12f692ce40f21c023cc9c65dfbcf39aa491fb3b6785061f54?s=96&d=blank&r=g\",\"width\":96,\"height\":96,\"caption\":\"CJD\"}},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#webpage\",\"url\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400\",\"name\":\"[VBA][\\u7f16\\u7a0b] VBA\\u4f7f\\u7528\\u201cTextFrame2\\u201d\\u8bbe\\u7f6e\\u5750\\u6807\\u8f74\\u5c5e\\u6027\\u51fa\\u9519 | \\u5d14\\u6d4e\\u4e1c\\u7684\\u535a\\u5ba2 - www.jdcui.com\",\"description\":\"[VBA][\\u7f16\\u7a0b][\\u5f00\\u53d1][\\u7b14\\u8bb0] VBA\\u4f7f\\u7528\\u201cTextFrame2\\u201d\\u8bbe\\u7f6e\\u5750\\u6807\\u8f74\\u5c5e\\u6027\\u51fa\\u9519\\u3002\\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 .Size = 12 .Bold = True End With \\u53ef\\u4ee5\\u4ece \\u5b8f \\u4e2d\\u770b\\u89c1\\uff0c\\u4ee3\\u7801\\u662f\\u901a\\u8fc7 TextFrame2 \\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 TextFrame2 \\u65e0\\u6cd5\\u8bc6\\u522b\\uff0c\\u4e0d\\u5b58\\u5728\\u3002\\u4e0d\\u77e5\\u9053\\u662fBug\\u8fd8\\u662f\\u4ec0\\u4e48\\uff0c\\u6700\\u540e\\u901a\\u8fc7 TickLabel \\u5c5e\\u6027\\u89e3\\u51b3\\u3002\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.jdcui.com\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/VBAFeaturedPicture.gif\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400\\\/#mainImage\",\"width\":352,\"height\":173},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/?p=9400#mainImage\"},\"datePublished\":\"2018-07-30T13:28:44+08:00\",\"dateModified\":\"2026-02-17T08:41:46+08:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/#website\",\"url\":\"http:\\\/\\\/www.jdcui.com\\\/\",\"name\":\"\\u5d14\\u6d4e\\u4e1c\\u7684\\u535a\\u5ba2 - www.jdcui.com\",\"description\":\"\\u5b9e\\u5e72\\u3001\\u5b9e\\u8df5\\u3001\\u79ef\\u7d2f\\u3001\\u601d\\u8003\\u3001\\u521b\\u65b0\\uff01 Tag: \\u7ed3\\u6784\\u5de5\\u7a0b\\u535a\\u58eb \\u7ed3\\u6784\\u5de5\\u7a0b\\u5e08 \\u4f2a\\u7a0b\\u5e8f\\u5458 \\u7ed3\\u6784\\u6297\\u9707 \\u5730\\u9707\\u5de5\\u7a0b \\u8d85\\u9650\\u8bbe\\u8ba1 \\u8f6f\\u4ef6\\u5b9a\\u5236 \\u73af\\u8bc4\\u51cf\\u632f \\u632f\\u52a8\\u63a7\\u5236 \\u51cf\\u9694\\u9707 \\u65bd\\u5de5\\u8fc7\\u7a0b\\u6a21\\u62df \\u5c0f\\u54c1\\u94a2\\u7ed3\\u6784 \\u6709\\u9650\\u5143\\u7814\\u53d1 \\u53c2\\u6570\\u5316\\u8bbe\\u8ba1 \\u5927\\u9707\\u5f39\\u5851\\u6027\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.jdcui.com\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519 | \u5d14\u6d4e\u4e1c\u7684\u535a\u5ba2 - www.jdcui.com","description":"[VBA][\u7f16\u7a0b][\u5f00\u53d1][\u7b14\u8bb0] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519\u3002\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 .Size = 12 .Bold = True End With \u53ef\u4ee5\u4ece \u5b8f \u4e2d\u770b\u89c1\uff0c\u4ee3\u7801\u662f\u901a\u8fc7 TextFrame2 \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 TextFrame2 \u65e0\u6cd5\u8bc6\u522b\uff0c\u4e0d\u5b58\u5728\u3002\u4e0d\u77e5\u9053\u662fBug\u8fd8\u662f\u4ec0\u4e48\uff0c\u6700\u540e\u901a\u8fc7 TickLabel \u5c5e\u6027\u89e3\u51b3\u3002","canonical_url":"http:\/\/www.jdcui.com\/?p=9400","robots":"max-image-preview:large","keywords":"excel,textframe2,vba,\u4e8c\u6b21\u5f00\u53d1,\u5f00\u53d1,\u7f16\u7a0b","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.jdcui.com\/?p=9400#article","name":"[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519 | \u5d14\u6d4e\u4e1c\u7684\u535a\u5ba2 - www.jdcui.com","headline":"[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519","author":{"@id":"http:\/\/www.jdcui.com\/?author=1#author"},"publisher":{"@id":"http:\/\/www.jdcui.com\/#organization"},"image":{"@type":"ImageObject","url":"http:\/\/www.jdcui.com\/wp-content\/uploads\/2018\/07\/VBAFeaturedPicture.gif","width":352,"height":173},"datePublished":"2018-07-30T13:28:44+08:00","dateModified":"2026-02-17T08:41:46+08:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"http:\/\/www.jdcui.com\/?p=9400#webpage"},"isPartOf":{"@id":"http:\/\/www.jdcui.com\/?p=9400#webpage"},"articleSection":"Programming [\u7f16\u7a0b], Excel, TextFrame2, VBA, \u4e8c\u6b21\u5f00\u53d1, \u5f00\u53d1, \u7f16\u7a0b"},{"@type":"BreadcrumbList","@id":"http:\/\/www.jdcui.com\/?p=9400#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.jdcui.com#listItem","position":1,"name":"Home","item":"http:\/\/www.jdcui.com","nextItem":{"@type":"ListItem","@id":"http:\/\/www.jdcui.com\/?cat=21#listItem","name":"Programming [\u7f16\u7a0b]"}},{"@type":"ListItem","@id":"http:\/\/www.jdcui.com\/?cat=21#listItem","position":2,"name":"Programming [\u7f16\u7a0b]","item":"http:\/\/www.jdcui.com\/?cat=21","nextItem":{"@type":"ListItem","@id":"http:\/\/www.jdcui.com\/?p=9400#listItem","name":"[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.jdcui.com#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.jdcui.com\/?p=9400#listItem","position":3,"name":"[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519","previousItem":{"@type":"ListItem","@id":"http:\/\/www.jdcui.com\/?cat=21#listItem","name":"Programming [\u7f16\u7a0b]"}}]},{"@type":"Organization","@id":"http:\/\/www.jdcui.com\/#organization","name":"\u5d14\u6d4e\u4e1c\u7684\u535a\u5ba2 - www.jdcui.com","description":"\u5b9e\u5e72\u3001\u5b9e\u8df5\u3001\u79ef\u7d2f\u3001\u601d\u8003\u3001\u521b\u65b0\uff01 Tag: \u7ed3\u6784\u5de5\u7a0b\u535a\u58eb \u7ed3\u6784\u5de5\u7a0b\u5e08 \u4f2a\u7a0b\u5e8f\u5458 \u7ed3\u6784\u6297\u9707 \u5730\u9707\u5de5\u7a0b \u8d85\u9650\u8bbe\u8ba1 \u8f6f\u4ef6\u5b9a\u5236 \u73af\u8bc4\u51cf\u632f \u632f\u52a8\u63a7\u5236 \u51cf\u9694\u9707 \u65bd\u5de5\u8fc7\u7a0b\u6a21\u62df \u5c0f\u54c1\u94a2\u7ed3\u6784 \u6709\u9650\u5143\u7814\u53d1 \u53c2\u6570\u5316\u8bbe\u8ba1 \u5927\u9707\u5f39\u5851\u6027","url":"http:\/\/www.jdcui.com\/"},{"@type":"Person","@id":"http:\/\/www.jdcui.com\/?author=1#author","url":"http:\/\/www.jdcui.com\/?author=1","name":"CJD","image":{"@type":"ImageObject","@id":"http:\/\/www.jdcui.com\/?p=9400#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/e2fdb66ee1ab31c12f692ce40f21c023cc9c65dfbcf39aa491fb3b6785061f54?s=96&d=blank&r=g","width":96,"height":96,"caption":"CJD"}},{"@type":"WebPage","@id":"http:\/\/www.jdcui.com\/?p=9400#webpage","url":"http:\/\/www.jdcui.com\/?p=9400","name":"[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519 | \u5d14\u6d4e\u4e1c\u7684\u535a\u5ba2 - www.jdcui.com","description":"[VBA][\u7f16\u7a0b][\u5f00\u53d1][\u7b14\u8bb0] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519\u3002\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 .Size = 12 .Bold = True End With \u53ef\u4ee5\u4ece \u5b8f \u4e2d\u770b\u89c1\uff0c\u4ee3\u7801\u662f\u901a\u8fc7 TextFrame2 \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 TextFrame2 \u65e0\u6cd5\u8bc6\u522b\uff0c\u4e0d\u5b58\u5728\u3002\u4e0d\u77e5\u9053\u662fBug\u8fd8\u662f\u4ec0\u4e48\uff0c\u6700\u540e\u901a\u8fc7 TickLabel \u5c5e\u6027\u89e3\u51b3\u3002","inLanguage":"en-US","isPartOf":{"@id":"http:\/\/www.jdcui.com\/#website"},"breadcrumb":{"@id":"http:\/\/www.jdcui.com\/?p=9400#breadcrumblist"},"author":{"@id":"http:\/\/www.jdcui.com\/?author=1#author"},"creator":{"@id":"http:\/\/www.jdcui.com\/?author=1#author"},"image":{"@type":"ImageObject","url":"http:\/\/www.jdcui.com\/wp-content\/uploads\/2018\/07\/VBAFeaturedPicture.gif","@id":"http:\/\/www.jdcui.com\/?p=9400\/#mainImage","width":352,"height":173},"primaryImageOfPage":{"@id":"http:\/\/www.jdcui.com\/?p=9400#mainImage"},"datePublished":"2018-07-30T13:28:44+08:00","dateModified":"2026-02-17T08:41:46+08:00"},{"@type":"WebSite","@id":"http:\/\/www.jdcui.com\/#website","url":"http:\/\/www.jdcui.com\/","name":"\u5d14\u6d4e\u4e1c\u7684\u535a\u5ba2 - www.jdcui.com","description":"\u5b9e\u5e72\u3001\u5b9e\u8df5\u3001\u79ef\u7d2f\u3001\u601d\u8003\u3001\u521b\u65b0\uff01 Tag: \u7ed3\u6784\u5de5\u7a0b\u535a\u58eb \u7ed3\u6784\u5de5\u7a0b\u5e08 \u4f2a\u7a0b\u5e8f\u5458 \u7ed3\u6784\u6297\u9707 \u5730\u9707\u5de5\u7a0b \u8d85\u9650\u8bbe\u8ba1 \u8f6f\u4ef6\u5b9a\u5236 \u73af\u8bc4\u51cf\u632f \u632f\u52a8\u63a7\u5236 \u51cf\u9694\u9707 \u65bd\u5de5\u8fc7\u7a0b\u6a21\u62df \u5c0f\u54c1\u94a2\u7ed3\u6784 \u6709\u9650\u5143\u7814\u53d1 \u53c2\u6570\u5316\u8bbe\u8ba1 \u5927\u9707\u5f39\u5851\u6027","inLanguage":"en-US","publisher":{"@id":"http:\/\/www.jdcui.com\/#organization"}}]}},"aioseo_meta_data":{"post_id":"9400","title":null,"description":"[VBA][\u7f16\u7a0b][\u5f00\u53d1][\u7b14\u8bb0] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519\u3002\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 TickLabel \u5c5e\u6027\u89e3\u51b3\u3002","keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2021-04-18 09:38:26","updated":"2026-02-17 00:57:08","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.jdcui.com\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.jdcui.com\/?cat=21\" title=\"Programming [\u7f16\u7a0b]\">Programming [\u7f16\u7a0b]<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.jdcui.com"},{"label":"Programming [\u7f16\u7a0b]","link":"http:\/\/www.jdcui.com\/?cat=21"},{"label":"[VBA][\u7f16\u7a0b] VBA\u4f7f\u7528\u201cTextFrame2\u201d\u8bbe\u7f6e\u5750\u6807\u8f74\u5c5e\u6027\u51fa\u9519","link":"http:\/\/www.jdcui.com\/?p=9400"}],"views":2899,"_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}]}}