![]() |
Textboxes in Excel 2007 Beta 2 Macros
I think I have 2 problems with textboxes in Excel 2007.
This line of code used to work in old versions: ActiveChart.Shapes.AddTextbox(msoTextOrientationHo rizontal, 415, 75.01 , 245, 17).Select Selection.Characters.Text = "My Text Blah Blah" But now, it does not work in Excel 2007 Beta 2. (Hangs up on the first line.) However, if I change "ActiveChart" to "ActiveSheet", and then click over to a non-chart sheet, it works fine. Next problem. I try record macros so Excel will tell me how to do it, but it seems it does not record the TextBox insert steps. Whether it be in a chart or sheet. Bottom line, I'd like to get some form of text labels on a bar chart. Any solution is appreciated. |
All times are GMT +1. The time now is 06:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com