Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Beta | Excel Discussion (Misc queries) | |||
Excel 2007 Beta Version | Excel Discussion (Misc queries) | |||
Excel 2007 Beta | Excel Programming | |||
Access Macros in Office 2007 Beta 2 | Excel Discussion (Misc queries) | |||
Excel 2007 Beta - can't edit macros | Excel Discussion (Misc queries) |