Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings:
I have the following line in an Excel VBA Macro: ActiveChart.Shapes.AddTextbox(msoTextOrientationHo rizontal, 500, 80, 120, 60).Select Selection.AutoScaleFont = False Selection.Characters(Start:=1, Length:=23).Font.Name = "Arial" It runs perfectly well under Excell 2003, but under Excel 2007, I get the following, very unhelpful, error message: "Runtime error: 1004 Unable to get the Characters property of the TextBox class." Sooo, what does unable to "get" the property mean. It doesn't exist? Has it been removed? Am I not using it properly? Most important: What has changed in Excel 2007 that this no longer works? Thank you, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Limit textbox to 255 characters | Excel Programming | |||
Textbox: Number of Characters | Excel Programming | |||
Validating number of characters in textbox | Excel Programming | |||
exact number of characters in textbox | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |