label

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...

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...

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

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...

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...

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

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...

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...

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...

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

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"

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

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...

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

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...

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...

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

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

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...

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...