ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Textboxes in Excel 2007 Beta 2 Macros (https://www.excelbanter.com/excel-programming/364957-textboxes-excel-2007-beta-2-macros.html)

[email protected]

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