label

Hello All, I have created an user form which has a frame. The frame contains several labels. My objective is to highlight the label when mouse points to a label but highlight should disappear once mouse moves to next label and the next label should be highlighted. Following is my code...

Hello All, I have created one user form which contains two combo boxes one frame called frame1 and one command button. Inside Fram1, I have 42 labels which are named from Label1 to Label42. From drop down of combo box, I select month and year. Based on these two values, caption of the label...

I'm using the formula in a cell to get the subtotal of a column, however, I would like to show the results directly on a userform label without having to use a formula to generate the results then caption the result to the label from the cell. Is this possible? I don't want have any formulas...

I have a very basic table (two columns) with thousands of rows. Column A has a label, and column B has an entry. There can be multiple entries (rows) per label, but the number of entries per label will vary. (original table) Label A, Entry 1 Label A, Entry 2 Label B, Entry 1 Label C, Entry 1...

If I've got the coordinates of the location where I want the cursor to go (can't use setfocus), what is the trick to move it to any given x,y coordinates? I've been able to find code to tell me the the cursor's position when it is clicked on a label, but when I'm done I want it to return to...

Hello What i want is to display 65 textboxes and 65 labels adjacent to each other in 3 or 5 columnar way on the userform at run time. Textbox and Label Top Position starts from 144 so when used the following in below code for both controls textbox and label .Top = 144 * i * 1 the gap between...

Hi all, This is my first post. First, thank you for reading. Second, I'm an average user of Excel, but completely new at macro's and VBA. I've searched around for days looking for an answer to this question, but haven't found anything that works yet. I know its simple enough to click and...

I have a vlookup cell in a spread sheet. I want a userform label to display the value from the vlookup in a note on the userform. I can't figure out how to link a cell reference to a userform label. Any suggestions? The label on the userform would say "The primary production line for this...

I am completely new to this and everything I've learned so far has been from this forum so thank you. Just one problem which I have found many answers but still can't solve. I have 2 sheets (Labels, Order Form). The Labels sheet contains the columns Description & Label ID, along with various...

I already dynamically create, many msForms.Labels on a Userform, with events; I know how to do that exceptionally well. When it comes to replicating that process to my worksheets; I'm totally lost. From the controls toolbox in excel, I see that I can manually add a forms or active label to my...

My company used to use printed sheets of paper with the product information which was then tape to the pallet of finished goods all this was done with an excel userform. Now they have gone to adhesive labels printed from Microsoft Word. Since I am not familiar with VBA within Microsoft Word, I...

On my userform i got a Multipage with the same function BUT with different Code so i match to the cells where to take action My command Button works As they should But my Label functions Kill's Mee On a Normal Userform i see Both Values when i run userform but Not on Multipage then i only see...

Is there a way I can use an Ampersand in my label?

Hi all, Apologies, I'm new to this and new to coding so I will sound as though I'm clueless! Im creating a userform through VBA and I need to get some of the boxes I have created (label boxes) to add up the value that is in the text boxes (in some cases I need them to multiply). Does anyone...

Someone sent me a workbook to look at "because its no longer working". What they sent was an XLA file. They said it use to add a ribbon to their tool bar but now it doesn't work with the latest version of XLS. Is this just missing a tool pack or Add-in that needs to be activated in her latest...

Hello, I have a spreadsheet contains several tables and column charts. Tables link t other worksheets by excel formulas. I have been using this file for a couple of month ad it used to work perfect. Since I have Several tables and charts, It is hard an crowded to make a presentation with the...

Hi, I have a workbook of pivot tables that use one data set. The workbook consists of a tab with the data on it, and 7 tabs with three pivot tables each, all which use that data set. The idea is to replace the data on the data tab daily with a simple copy/paste values. The headers remain...

I am trying to tie a formula capturing my "n" number into a label on a chart and doesn't seem to be working it is showing the formula written out instead of the formula working and providing the result, here is my formula ="n="&A$4. Is it possible to have a formula incorporated into an axis label?

Hi Folks, I have excel data---columns A and B---populated by 3 digit numbers <tbody> 278 192 148 112 168 325 279 261 306 38 292 259 135 654 </tbody> There are a few thousand lines of these numbers. I would like to import these numbers (one number per label in the same layout as...

I need date to be displayed in userform label however date must be taken from a cell and must change at 24 mark [ see the image below]. Please help :confused: https://imgur.com/JZ0cRUD