label

  1. M

    Opening .xlsx file and changing a form control label using a .xlsm workbook

    I have a workbook that opens another workbook. Can I control the caption on a label using a separate workbook that is running all my code? Below is my code... but I have an error in the last line. Private Sub CommandButton1_Click() Dim Wbk1 As Workbook Dim Pth1 As String Dim...
  2. H

    Data labels color in stacked bar data chart

    I do have 3 series in a stacked bar chart. The fourth series is a data label displaying the date. I need to display different color for the label based on a column that as Yes or No values; ie., display data labels in red color if it satisfies Y and display in green if it satisfies No. How to...
  3. IluvPivots

    Label Last Saturday

    Column A lists dates. How do I get Column B to label the last Saturday of the month?
  4. W

    A new Lookup Question

    Hi All, This is similar to a previous question I asked, but the table I needed to create for the other option was becoming way too large and cumbersome and the lookup number had to be in multiples of 1000. Here is my dilemma... I am creating a label quote system. There are 10 Groups of...
  5. D

    Change the name of a Cell to Text label using another cell and it uses anther value cell for calculations

    Hello I am using Microsoft Excel 2013. I am working on an estimating bill of quantities for Civil Engineering. In the Excel sheet 1 is the summary sheet 2 is the Office over heads and other costs sheet 3 is earth works sheet 4 concrete. In sheet 5 I want to build up the rates to use in each of...
  6. F

    Label Filters in Pivot Table

    I have a pivot table that returns a sum value (number of days) per week number (formatted as 2019-23) I need it to only show weeks for the past year, so basically >(This week -51). I've tried setting the filter, using NOW() but can't it to work. Any suggestions? Thanks, BeckieO
  7. B

    Why (Blank) row label appears when I add relationship to another table

    I have a PowerPivot model with two tables in it (let's call them "Table A" and "Table B") Both tables include a field for "Client Reference" When the tables are not connected by a relationship, if I place the "Client Reference" field from "Table A" as the row label in a Pivot Table, there is no...
  8. S

    Checkbox True value not being picked up at other activities

    I have a Userform which is populated from a worksheet using a Combobox selection, or data is added to the userform and then added to the worksheet. Within the Userform I have a Checkbox that indicates if a certain piece of paperwork is present for that specific Project. If this Checkbox is true...
  9. D

    Listbox value not updating on userform and label not updating font settings

    Hello, I have a project where I am creating a font settings box to allow a user to change settings within some defined limits. Almost everything works as expected, but there are two issues. 1. At different times, one of three Listboxes on the userform, while having the correct value selected...
  10. A

    autosize text to fit a fixed userform label

    How can I resize text to fit a userform label without resizing the label (I want the label size to stay fixed). Thank you kindly for your help
  11. Y

    listbox value to label's caption

    I have a listbox with multi column, using this code listbox1.value = label1.caption the label only displays the text on the first column without the remaining columns. for instance, cat pillar the label should display "catpillar"
  12. M

    Dynamically Changing Multipage Label Caption

    I have a multipage with a label on page 1. I want the label to reflect what is in cell B5, but it doesn't do anything no matter what I try. Any ideas? Private Sub FeesForm_Initialize() Dim ws As Worksheet MultiPage1.pgTerm1.lblTerm.Caption = ws.Cells("b5") End Sub
  13. L

    label.caption = 1

    Hi I just watched a video. He created a form then inserted a label and a command button. Then he made the label Caption =1, then clicked on command button and wrote the code below. So when a user click the button the caption will increment by 1 Why is that? I changed the caption from 1 to Hello...
  14. A

    Separate Numbers

    I have a code that prints the 52 week range (i.e. 49.77 - 79.90). I would like to separate the numbers (49.77 & 79.90). I would be using each number in a label. Can someone assist. Thanks
  15. 1

    Change hover label data on Scatter plot chart

    Hi, I have 8 scattered plot charts, all containing more than 300 dots.. This means that I cant use ordinary labels, because it destroys all visibility of the chart. So I need to hover the dots to see the label data. This works good but I cant manage to get the names of the items on the...
  16. D

    Accumulative date stored in a caption

    I have 14 boxes for a calander and above the each box is a label. I want to put the date of the first day in the fortnight above the caption of the first label. I then want it to auto fill to the other labels to add one day for each label so the date above each box represents the dates in the...
  17. D

    Copy and paste to the caption of a label

    What is the vba code to copy text in a cell I25 and paste it in the caption of a label?
  18. S

    Display only specific data label in the line chart

    I need to get only specific data label ( x,y cordinates) displayed in the line chart. The specific line in the data sheet can be identified based on the comment (start & finish) in the adjacent column
  19. A

    Concatenate

    Hello Saviors! I am working on creating a Master Contact List collating data from various places. This is an exercise to create an invitation list and hence I keep coming back to take your help. My sincere gratitude to all of you. To come to my problem, I am trying to use concatenate the...
  20. K

    If value in list, then assign label

    Hi All, Good morning/afternoon/evening depending on where you are in the world. I've run into a little problem on this fine Monday morning! I feel like its a really easy one and I'm just being an idiot, or the weekend hasn't quite worn off completely I'm not sure! I've tried looking online and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top