Change Chart TextBox 1 Caption Via Macro?

Jul 18, 2014


I am trying to edit a textbox caption in an active chart with a macro and cannot figure out the correct way to reference the text property. I have been successful in editing other items within this chart via the complete code below (i currently have textbox edit commented out)


I know i can set it up with a helper cell to have the textbox reference a range (that updates with the text i want) but i'd to try and edit the text without the use of helper cells to try and make this a little more break resistant.

View 5 Replies


Change Label Caption When Textbox Selected

Jun 11, 2008

I'm buildng a userform for data input.

As an aid, I have a label at the bottom of the form and when a person tabs onto a textbox that labels then states what you are supposed to input into that textbox along with an example. When you tab onto another textbox the caption on the label changes to give another explanation and example.

I attempted to insert an if statement into the userform which states that if a textbox is enabled then the caption of the label = "Example"

If textbox1.enabled = True Then label1.caption = "Explanation 1, Example 1"
If textbox2.enabled = True Then label1.caption = "Explanation 2, Example 2"
End If
End If

View 5 Replies View Related

Macro To Change ActiveX Label Caption?

Mar 2, 2014

I needed to put a Checkbox on a Worksheet. The standard Checkbox options in Excel FormControl and ActiveX Control were too small. I found a work-around using the following macro attached to an ActiveX Label that was formatted as Wingdings font. The macro basically changes the character from a empty box Wingdings Chr(168) to a checked box Wingdings Chr(254) when the user clicks on the label.

Private Sub Label1_Click()
If Label1.Caption = Chr(254) Then
Label1.Caption = Chr(168)


But I get this error on an ErrorHandler that I have included in the macro. "An error has occurred. Error number =438. Error Description=Object doesn't support this property or method."

View 3 Replies View Related

How To Set Label Caption To Update Once Textbox Value Is Changed

Feb 26, 2013

I have two text boxes on a userform that are used to populate a label caption based on the textbox values. How do I set the label caption to update once a a textbox value is changed?

View 2 Replies View Related

Hide Button Or Textbox Based On Caption Across Multiple Sheets

Oct 16, 2009

I have a workbook with 31 sheets. Each sheet has 15 textbox button that call macros.
I would like to hide 1 textbox on all sheets until another macro is called. I know how to get the textbox names to be able to hide them, But because these text boxes were copied most of the are the same name, however on severl sheets they are different names "Textbox 4 on most sheets but it could be textbox 34 on others. The ones I want to hide all have the same text label. Is it possible to get VBA to return the label text.

View 8 Replies View Related

Change The Caption Of OLEobjects Label?

Aug 5, 2014

I'm trying to change the caption of a label (OLEobject) and it is not working so far :


View 2 Replies View Related

Label Caption Change... Run Code

Sep 30, 2009

I have just noticed that there is no defult event for the running code after updating a label caption. I would like to have like a textbox does (Change,AfterUpdate). to run code on the label caption change. could it be done with activex?? can it be done at all.??

View 2 Replies View Related

Change Caption In Modeless UserForm From Another

Feb 2, 2008

Background: I currently have an some VBA code that will kick off a series of calculations on a remote server (7 calcs). I am showing a modeless form, to allow the user to continue to work in Excel while the external calculation is taking place. The code checks every few seconds (using .OnTime) to check the status of the calcs, and as one finishes, it starts the next calc, and updates the form (ie - "Running Calc #3 of 7", etc).

'Do calc
'Finish calc
frmProgress.labMessage.Caption = "Running Calculation: 'Revenue'"
'Do another calc
'Finish another calc
frmProgress.labMessage.Caption = "Running Calculation: 'Labor'"

Problem: when I change the label on the form, it gives the form focus. So, if the user is in the middle of doing something, they are suddenly stopped, and have to click back on the spreadsheet to continue.

Questions: Is there a way to update content (label) on a form, without that form getting focus? If not, is there another way to provide updated feedback without disrupting what the user is doing? My fallback is to simply not update the form with progress reports, but since the calcs can take 5min or so, it would be good if they knew things were progressing.

View 3 Replies View Related

Change Button Shape Caption

Feb 14, 2008

How do you references the properties of a shape? I am having trouble with 2 different types. Firstly, I have a worksheet with a group of commandbuttons (all added using the Control toolbox) and I want to loop through them changing, for example, the enabled property of each to TRUE.

Secondly, I have some commandbuttons on a worksheet (added using the Forms toolbox). How would I loop through changing, say, the text on the buttons. I used the macro recorder to try to get an idea and got the following:

Sheet1.Shapes("button 15").Select
Selection.Characters.Text = "New Text"

Although this works, it is not very elegant, how can it be achieved without selecting the button each time, but rather by directly accessing the property.

View 3 Replies View Related

Change Caption Of Label & UserForm

Jun 20, 2008

I present a form (a calendar) twice in my routine to the user but I want to change the Caption of the Label on each pass?


The first time it's displayed: 'Please select a start date' (calendar closes & goes off and does stuff)
... and on the 2nd display: 'Please select an end date'.

View 7 Replies View Related

Change Form Caption To Cell Value Or Variable

Sep 24, 2009

it's possible to change the caption (title) of a user form to a variable or cell value? Or does it always have to be hard coded?

View 2 Replies View Related

VBA - Change Caption Of ActiveX Checkboxes Using A Loop

Jan 24, 2013

I am trying to change checkboxes caption name using a loop so that I don't have to change them individually. Here is a simplified example of what want to do:

1) I save the caption names in a array
2) I run through a loop to rename each checkboxes using the names saved in the array

Sub change_Checkbox_Caption
Dim MyArray(1to3) as string
Dim IndexMyArray as integer
MyArray(1) = "YES"
MyArray(2) = "No"
MyArray(3) = "Maybe"


View 2 Replies View Related

Change Of Toolbar Item Caption Does Not Work

May 14, 2009

I am trying to change the caption of a toolbar item but for some reason it does not work.

Application.CommandBars("Format").Controls("Item...").Caption = "I&tem..."

for example works just fine

View 9 Replies View Related

Change Caption Property Of Option Button

Mar 23, 2007

I have a problem with the changing the caption property of the option buttons to bold, italic and regular.

Is it some vb code you need to put in for the option buttons?

View 8 Replies View Related

Change Caption Of Dynamically Created Label

Jun 26, 2007

For a form that dynamically creates a series of text boxes and labels, does anyone know how to change the caption of a dynamically created label to display the value of a cell in a worksheet? The cell in the worksheet changes according to input on the text boxes. In the form's code, I have:

Dim newLblFreq As MSForms.Label
Set newLblFreq = Me.Controls.Add("Forms.Label.1", "lblfreq" & i, True)
newLblFreq.Caption = Range("V" & i).Text & " Hz"

But once the label is created, the caption won't change, even if Range("V" & i) changes...............

View 6 Replies View Related

Change Output Of Option Button To Caption Or Name

Jan 11, 2008

I'm a complete Excel and VBA newbie and would like to know if it's possible to change the output of OptionButtons from 'TRUE' or 'FALSE' to "1"/"2"/"3"/etc..

The name of each button is:

Rating 1
Rating 2
Rating 3
Rating 4
and so forth..

The idea is for each rating to output its assigned number such that if the user were to click "Rating 1", the result would be "1", "Rating 2" = 2 and so on. I'm trying to design a survey and these results will then be used to calculate an average rating. If this is possible, how would I need to write the code for it?

View 2 Replies View Related

Change Label Caption Based On Scrollbar Value

Feb 1, 2008

I'm amtepting to populate some labels from some predefined strings based on the scrollbar value. I have these codes:

Option Explicit
Public Meddelande1 As String, Meddelande2 As String, Meddelande3 As String, Meddelande4 As String, Meddelande5 As String, Meddelande6 As String, Meddelande7 As String, Meddelande8 As String, Meddelande9 As String

Private Sub UserForm_Initialize()
On Error Resume Next
Workbooks("Kontrollsystemet.xls").Close SaveChanges:=False
Application. ScreenUpdating = False
Workbooks.Open "V:allaBeredningKontrollsystemetKontrollsystemet.xls", ReadOnly:=True
Meddelande1 = Range("B2").Text
Meddelande2 = Range("B3").Text....................

View 2 Replies View Related

Change Toggle Button Caption On 2007 Ribbon

Jul 1, 2008

I currently upgrading some add-in to Excel 2007. This one concern a toolbar or Ribbon as they call it now. I am creating a toggle button using XML

<customUI xmlns="">
<tab id="rxTrading" label=" Trading" >
<group id="rxDownloadStockData" label="Download Stock Data" >
<button id="rxDownloadData" label="Download" onAction="rxDataStock_Download" />
<toggleButton id="rxEnableDisableDowwnload" label="Enable Download" />

How can I change the name of toggle button to "Disbale Download" after clicking on the toggle button? I am trying to find the answer on WROX Excel 200 VBA but I am lost.

View 2 Replies View Related

Conditionally Show/Hide Columns & Change Button Caption

Jan 22, 2009

After scouring the entire OzGrid, I have found the following two macros that partly satisfy what I want to achieve. BTW, following two macros are executed on Sheet2 and I want to achieve the following:
On Worksheet_Activate, show columns that match the criteria value in Sheet1.D4 (Sheet1.D4 contains a dropdown list with about 6 text values). In addition to that, if Sheet1.D4 value is blank then show all columns. Right now, it successfully shows columns that match the D4 value but does not work if that D4 value is left blank, instead it hides all columns in range (C:CV). So in short, to the first macro, I need to add the criteria if D4 is blank, then keep the sheet intact and don’t hide anything, just show all columns.Once on that sheet after the Worksheet_Activate event has occurred, with the second macro “ToggleColumnsVisibility” following things need to happen. BTW, currently this macro is assigned to a button (from Forms Toolbar).If cell D4 has a value, then the button’s caption should read “Show All” and when that button is pressed, it should show all columns in the range (C:CV), and the button's caption needs to change to “Show Selected”. In “Show Selected” mode, when that button is pressed, it needs to show all the columns that match the D4 value.If cell D4 is left blank, then the button's caption should read "No Action" and when the button is pressed, it should not do anything but just show all columns.

As you will notice in the header, my experience with Excel is very limited, so detailed instructions will be greatly appreciated. I am also hoping that proposed solution uses some of the efficient/effective ways of using loops such as described below (example taken from this website from this link

Sub TrueOrFalseFaster()
Dim bYesNo As Boolean
Dim i As Integer
bYesNo = (i = 5)
MsgBox bYesNo
End Sub

Sub ToggleTrueOrFalseFaster()
Dim bYesNo As Boolean
bYesNo = Not bYesNo
MsgBox bYesNo
End Sub .........

View 9 Replies View Related

Change Order For Chart Series Collection Macro Code

Mar 18, 2008

I have a bar graph with 2 series of data. Anyone knows how I can specify the order in which they appear? code looks similar to the following. The bar graph shows the second series before the first series. How do I reverse the order?

With cht
.ChartType = xlColumnClustered

' first data series
Set ser = .SeriesCollection.NewSeries
With ser
.Values = someValues
.XValues = someValues
End With

' second data series
Set ser = .SeriesCollection.NewSeries
With ser
.Values = someValues
.XValues = someValues
End With

View 2 Replies View Related

Excel 2010 :: Change Default Pie Chart Colors In Recorded Macro?

Mar 20, 2014

I am working on a project where I am virtually almost finished except for a minor change with the pie chart. I am analyzing some data and recorded a macro to do this and also the pie chart for visualization. However, I do not like the color of the default pie chart colors and would like to customize it. How could I change this within the macro I have recorded?

[Code] .....

View 4 Replies View Related

Alternate Button Macro & Caption Between 2

Apr 23, 2008

I have a worksheet with 2 buttons labelled "Hide" and "Show". As the names imply, they allow the user to hide or show parts of the worksheet. I would like to combine them into one button and have the button label and the associated macro change with each press of the button. Here is what I have so far;

Selection.EntireRow.Hidden = False
ActiveSheet.Shapes("Button 20").Select
Selection.Characters.Text = "HIDE LEADS"
Range("A1").Select 'is there a better way to remove the focus from the button than selecting a cell off the button?
End Sub

Selection.EntireRow.Hidden = True
ActiveSheet.Shapes("Button 20").Select
Selection.Characters.Text = "SHOW LEADS"
End Sub

These macros change the label fine after hiding or unhding the rows but I can't find the proper terms to use to change the macro associated with the button (if there is one?)

View 4 Replies View Related

Change Chart Series Pasted From Another Chart

Jun 19, 2008

I want to use a macro to change attributes of a series in a chart. Unbelievably, if the series has been pasted into the chart from another chart, and although the macro can address the series and even return values (eg name) correctly, the selection simply cycles to one of the original series on the chart.

View 3 Replies View Related

VBA - Combobox And Textbox Value To Create Pie Chart

Oct 22, 2013

combobox1 = dog, texbox1 = 1500
combobox2 = cat, textbox2 = 1000
combobox3 = duck, textbox3 = 750

Is it possible to type in VBA coding to create a pie chart in excel with comboboxes and textboxes value?

View 3 Replies View Related

Setting Autoscalefont In A Chart Textbox

Mar 26, 2007

I can't figure out how to use VBA turn off autoscalefont in a chart textbox. .. (this is a textbox I have created in a chart using the shapes.addtextbox method..

View 8 Replies View Related

Linking Textbox In A Chart To Cell Reference

Feb 14, 2014

I've created a bar chart that I want to add some text boxes to. I want the text boxes to read what is in Cell A1 for example as the information in that cell will change over time.

How do I create a link between the information displayed in the text box and what's in Cell A1?

View 1 Replies View Related

Excel 2010 :: Place Textbox Between X Axis And Bottom Border Of Chart

Oct 27, 2011

In Excel 2010 I need to place a text box between the X axis and the bottom border of a chart.

How can increase the white space between the X axis and the bottom border to allow me to do this?

View 1 Replies View Related

Excel 2007 :: Find And Format Text Within Chart Textbox Object?

Nov 15, 2012

I have a text box within a chart tab which is populated with text values from a worksheet within the workbook. That part works fine however i want to be able to achieve the following example:

Current Text: Component Name - Notes

if there are notes against the component name i want the name to remain in black and the notes to change to blue

Aim: Component Name - Notes

If there arn't any notes then for the component name and the "-" to change to a light shade of grey

Aim: Component Name -

There are 26 components, each on their own lines in the textbox so im thinking either a loop where the cell reference is variable eg. ("CY" & i) or using the .find with a variable.

My code so far is:

Sub Chart_Notes_NTCA()
Dim i As Long, j As Long, Counted As Long, Total As Long
Dim Ans As String, Notes As String
Dim Cht As Chart


View 9 Replies View Related

Chart Hyperlinks: Attach A Macro So That When The Chart Is Clicked It Returns To Sheet - Home

Feb 24, 2007

I know this has been discussed a number of times, but here is my problem
I have three charts in my workbook. I want to attach a macro so that when the chart is clicked it returns to Sheet - Home. I have using the following:
worksheets("Home").activate. But after I protect each chart and the workbook, and save and exit. When I reload the Workbook it has forgotten the assigned macros and nothing happens.

View 7 Replies View Related

Change Textbox Properties

May 25, 2007

I am having a hard time setting the MultiLine, Scrollbars and WordWrap properties through programmation. Actually what I want my code to do is to create a set of textboxes in my spreadsheet and then set the MultiLine, Scrollbars and WordWrap properties. Right now I can create the boxes and rename them but I'm unable to change the other properties.

inst_num = Range("AA1").Value

ActiveSheet. OLEObjects.Add("Forms.TextBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=20, Top:=95 + (inst_num - 1) * 105, Width:=70, Height _

ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=100, Top:=95 + (inst_num - 1) * 105, Width:=100, Height _

View 2 Replies View Related

Copyrights 2005-15, All rights reserved