label

This is a tough one, rather special situation. We use serial number labels printed by Zebra Thermal Transfer Printers. The labels were created using the Zebra Pro Label software. After a label is created, the file is saved as a file extension .lbl. The labels are created linking fields to an...

Hello, I'm trying to remove the row label title from my pivot chart horizontal axis without removing the row labels that describe each columns themselves. How do I do this? Thanks for your help!

I am looking for assistance creating a formula toautofill labels from data in a table. Preferably a method that autofills insequence as there are thousands of lines to create labels for. The table below has the information to be transposed onthe label. The challenge is getting the next label...

The boss wants an icon in each data label of a 6-slice pie chart. I can insert the image into the label but it often covers the text and value. Can I create a label for text/value and a second for the image? I can't put any of these values into the pie slice because some of the slices are quite...

So my boss wants access to say guppy. None of my tables have that field. I was thinking of building a table and label it guppy. I'm doing a query to show forecast.i will like to know the easiest way to show guppy.

Hi al, For some reason I can’t seem to get this to work. I’m trying to set the caption of a userform label based on acell value. I’m using the following VBA Private Sub UserForm1_Initialize() lbl_date.Caption =Sheets("August").Range("A3").Value End Sub The label name and sheet name are...

Evening All, I'm tidying up a spreadsheet and giving column ranges label names and creating tables to better handle several columns of data. But I seem to have to duplicate everything with a label as the table columns are not acceptable as a Source in Data Validation list creations. Is this in...

Good afternoon, I was curious if someone could help me figure out how to find a font for a UPC Code in Excel; I already have the list of numbers, I just need the font to appear and I need to be able to print it.. Thank you for your assistance!

I have a userform with a textbox that can be changed by the user. I would like the text entered by the user to appear in a label. How can I have the label change only after the user stops entering text (I don't want it to change while the user is typing). Can someone help me out with this? Thanks!

Hi, i have a list of data on sheet("data") in columns A:C in the following format: <tbody> OrderNumber Quantity CountryCode 0001 12 01 0002 1 01 0003 4 02 0004 1 03 0005 6 04 0006 1 04 </tbody> I need to copy everything with CountryCode 01 into range "label01" on...

hi & good evening unsure if this applicable to this site..but here goes. I am needing create mail merge labels from excel, but when I insert the applicable fields into word & preview, it displays a sheet full of 1st entry. I need to have a label for each record on each sheet ( example)...

I have a need to link a text box in a user form to cell that contains a formula. I would then want to disable the text box to prevent user entry. My reason for this is that I wish to have the text box (other other indicator) on the form to automatically update its value when the cell it points...

hi I need help, I have a label that displays the date and time "dd-mmm-yyhh:mm ampm" once the user form shows I have 2 images that I want it to show based on theresult of what the time is currently. for example if the label says 07-Jul-18 06:00 am and the label is within 20minutes of the...

I have a userform with a combo box where you can select various models of valves. Depending on what model you select I would like another combo box to appear which is linked to a named range. There are 6 different model number to chose from so I need 6 different combo boxes to appear & 1 free...

Hi All, Is there a way to get the picture number of a picture previously inserted in a worksheet so that I can erase it by selecting "Picture" & x, the latter being the suffix number of said pix? Thanks, Chuck

I have a user form with a combo box that has a mist of dates. When the user selects the date i would like the labels to change. EX: the user selects 6/18/2018 and the labels change to 6/18/2018, 6/19/2018, 6/20/2018 etc. EX: the user selects 6/25/2018 and the labels change to 6/25/2018...

I am looking to create a scatter plot in Excel and looking through the other posts have not seen how to accomplish what I am looking for with the format of my data. I am managing 40+ projects and would like to show the variance by month of forecasted spend versus the actual. The resulting...

Hi, I have some code that I used to format the controls of a form. I know want to re-use that code to format other/different User Forms My code is: Private Sub UserForm_Initialize() Dim ctrl As Control 'Loop Through each LABEL control on UserForm->frmTxAdd For Each ctrl In...

I am guessing its not possible but figure I would ask. Can you change the font color for only parts of a userform label caption?

So I'm using a SumProduct array to sum values from an input sheet if they match both a row label (month) and a column label. This has been working well, but now I'm trying to expand it to sum if it matches either of two column labels. Here's the original formula...