View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bwillis88@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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.