Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text Box Name Search

Status
Not open for further replies.
Horstt

Horstt

Technical User
May 17, 2001
14
US
I am trying to add a text box to an Excel graph if one does not exist. How can I determine if one has already been added?

ActiveChart.Shapes.AddTextbox(msoTextOrientationHorizontal, 3#, 367, 750, 23).Name = "SC_TxtBox"
ActiveChart.Shapes("SC_TxtBox").Select
Selection.Characters.Text = _
"Special Cause Points: One point beyon ...
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Outlook Template replace text 2
Replies
13
Views
2K
Andrzejek
Andrzejek
M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
583
mintjulep
M
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
414
linuxguyEastCoast
linuxguyEastCoast
arvarr
  • Locked
  • Question
Rename Connection Name (Data Connection) 2
Replies
4
Views
302
arvarr
arvarr
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
504
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top