label

  1. B

    User Form Label format (date)

    Hi all. Long time watcher first time poster. Have searched he’d for a few days and am stuck on the below I have a user form that populates Labels with a date from a cell in a worksheet the date in the worksheet is in standard format. dd/mm/yy and is imported to the user form with no issue...
  2. JTL9161

    Sumproduct/Match

    I am having a brain block. I have 4 columns with number and label. a1:a30 are numbers, b1:b30 are labels. C1:c30 are numbers, D1:D30 are labels All in random order. I am trying to match the labels in column B to the label in Column D and then add the 2 numbers corresponding numbers in column...
  3. N

    Change Label color based on caption in Label with VBA code

    Hello, I have a userform with a label "txtRest" using the following code to get the total amount. (this code is in subroutine "txtTotal_Change") Me.txtRest = (IIf(Format(Me.txtTotal, "#,##0") = "", 0, (Format(Me.txtTotal, "#,##0"))) + 0) - (IIf(Format(Me.txtPaid, "#,##0") = "", 0...
  4. TAPS_MikeDion

    Formatting a label caption as "$##,###.##"

    Does anyone know why I cannot get the following code to show the digits after the decimal point in my label caption? Budget is the label name. Everything works great except for the fact that I can't get it to display the cents. 1900 displays as "$1,900." 1900.00 displays as "$1,900." No...
  5. K

    Column match on same row

    I have a table with Sku and Item Name. There are multiple lines with the same Sku. I want to take this information and create a table showing one line for the sku name and place an "X" with the Item Name that make up the Sku. Beginning data table <colgroup><col><col></colgroup><tbody> SKU...
  6. M

    Sub event that evaluates changing label in UserForm???

    I have a label that changes occasionally. If this label is one thing, I want the CommandButtons in my userform to be locked... If it is the other option, I want the command buttons to be unlocked. I've tried to use Label1_Change() but it doesn't seem to work. Any ideas on how I might achieve this?
  7. W

    Checking a textfile name for changes and enable a label

    Hi. Is there a way for excel to check a certain .txt file at startup (in a spesfic folder(and file)) for changes made (like higher number(versions)) then make a label enabled in the program ? (label7.enable) Example. Versions.txt (inside the file it says v1.0, then if i change it to example...
  8. 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...
  9. 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...
  10. IluvPivots

    Label Last Saturday

    Column A lists dates. How do I get Column B to label the last Saturday of the month?
  11. 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...
  12. 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...
  13. 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
  14. 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...
  15. 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...
  16. 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...
  17. 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
  18. 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"
  19. 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
  20. 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...

Some videos you may like

This Week's Hot Topics

Top