label

Hi guys, First post on this forum . I have a table with a list of initiatives - First column: the number of the initiatives - Second: Description of initiative - Third: Type of initiative (3 different types: digital tool, IT change, Process change) - Fourth: Impact score (0-5) - Fifth...

Hello, I have a spreadsheet that has multiple columns of data. I need a macro that will prompt the user to select a row, then concatenate the info into another cell. The point of this is so the data can be copied, and pasted into a label maker. This label printer only prints from its...

Hello all, Im using the code below to show or hide a label when the caption of some other label is 145; the lblDisplaying is used to display how many search results are found. When i don't search on any search term there are 145 search terms and i don't want to display the label then. If...

Hi all, I am doing a vlookup on loop and it is taking a long time to cycle through 20,000 rows. I am new to arrays, dictionary etc so looking for some guidance on this one. Much appreciated. Here is the code that works fine albeit slow along with some sample data: Sub test() Dim rng...

I'm having trouble with zOrder. Is it for Form controls, or not? I see references to shapes but not sure what they are. I've tried msoSendToBack (1), and msoBringToFront (0) each way on a Useform label and listview control and nothing does anything. According to MSHelp there's also...

Hello Fellows, I have created a RibbonX dynamic buttons. The progran reads a list in Excel column to create the buttons for the control. The entries in the Excel column are used as labels for the dynamic buttons. A common Callback routine is used for each button. That is, the butt******* for...

I am describing this as generic as possible and hopefully with someone help I can expand on it to solve my dilemma. I am importing the array noted below from our database (.txt file to .xls) B1 = label "Item-A", C1 = label "Item- B" D1 = Blank, E1 = Blank I need a formula in A1 that will look...

Hi, I have below macro that create boxes and I need to show only the bottom borders of these boxes, can anyone help me with that? '''BUILD THE eCnt LABEL BOX''' ew = galaxyF.Width / 2.3 eh = galaxyF.Height / eCnt el = galaxyF.Left et = galaxyF.Top + (eh * (e - 1)) Set...

Workbook has two worksheets, "Contractor Names and ID code" and list of all contracts with requirements i.e. type of contracts = "A, B, C or Blank", schedule dates and other items on second worksheet label "Contracts". On the first worksheet need to have the number of type contracts each...

i have 2 columns of data ( label text ) the labels are location specific , the 1st & 3rd column details the location for each. how can my spreadsheet merge the 2 label columns so that the locations are in progressive rows? so my data is F,G,H,I and i need J,K to auto sort F is location, G is...

Hello, Can I get help with the code given below. I'm trying to change back color of label.:) Thanks.. Private Sub Label1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) With Application Me.Label1.BackColor = 15773696 End With End Sub

is it possible to display the name of a sheet in a cell on that sheet?

Hi. I got a userform, and a sheet. In the userform, i got a button that saves the date i the A row, and a spesific value in the B row, then next time i press that button, it adds a new date in A, and B. Example. A1: 19.02.20 and in B1: 1,5 And if i press the button again, it goes like: A2...

Hi. I've googled a lot, tried alot, but cant get it to work, so i'll ask here. Im looking for a simple way to make a countdown timer in a label. I want it so when the userform loads, a coundown timer from 5 min shows in a label, counting down, in min and sec. Does anyone know how to do this?

I have a workbook with a tab called "input" there are peoples listed names in Row 13, I have another sheet called "labels" I would like the names typed in on the "imput" sheet to be transferred over to the "label" sheet in ColumnB, I tried the Copy and Transpose and It works but if I change a...

Hello, and Thank You in Advance. I have an excel user form with numerous labels (from the form tools). When you click on the label, it initiates the code below and cycles through three colors. I have used this in the past and a friend of my had simplified the coding to pull from one location...

Hi, I'm doing a chart trick with text labels and no values. User enters an event into a table, then the text label will appear on the chart (line invisible) . This is to track events for each month. The problem is when using the Label Options "Value From Cells" option where you select the...

Hi Everyone, I found this great macro from Ben Collins which will pull gmail data based on labels. His macro was more complicated than I needed with removing duplicates. Though his only had the name and email, whereas I need the date and subject as well. The error I am getting is the final...

Hello I have an issue with a macro running till the end instead of waiting for a called userform input. Below is the the code and the called userform code. As you see the SamOpt2x macro finds a cell containing "Sample #1 " and selects the cell. At that point the userform macro is called and...

I am getting this message frequently - a rather simple example is Sub newSub() On Error GoTo SRTT J = 3 / 0 End Sub SRTT: Stop End Sub I have even reloaded Office 365 Can any one help, please?