Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Sub TextBoxes_Add_ToCharts() 'Add text box 'You can assign the result of the AddTextbox method to a Shape object variable and manipulate its Top, Left, 'Height and Width properties '1. Value = Left property '2. Value = Top property '3. Value = Width property '4. Value = Height property Dim chtTemp As Chart Dim objTemp As Object Dim x As Integer x = 1 Do While x <= ActiveSheet.ChartObjects.Count Set chtTemp = ActiveSheet.ChartObjects(x).Chart Set objTemp = chtTemp.Shapes.AddTextBox(msoTextOrientationHorizontal, 285, 171, 135, 20) objTemp.Select Selection.Formula = "='" & chtTemp.Parent.Parent.Name & "'!Blue_Range_TextBox_" & Format(x, "00") x = x + 1 Loop ActiveCell.Select End Sub
|Excel 2013 Problem||12||44|
|Run-time 91 error, not sure why||3||21|
|Excel VBA - open a DataValidation dropdown||6||16|
|Dear Rgonzo please help making the code work in personal workbook to enforce it on any active workbook.||3||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!