code & vba

Hi, we want to print on label through excel, we have the following data which is not set for print label, how can we format the data and print on label (for example we have set the data in sheet2 we have the printing sheet (12 labels) A4ST12 100S (100X44.1)mm Data Sheet P CT...

Hey Everyone! So I am getting a bit stuck here - I have a timer that works (for the most part) the issue is when the userform is hidden and re-opened the "Continue" feature doesn't work anymore. Meaning the timer doesn't continue counting. Hope I can get some help please see my code below and a...

Hey everyone, hopefully a simple question - can I code a way for the [x] button to Hide the userform instead of unload/reset my code?

Hi Experts, I cannot upload the excel file as I am using office computer. I have made a sample below table: First four Coolum is my definition where the start / end date along with start and end time is mentioned. From Column 5 I want to do a plotting of 1 based on first 04 columns. If the...

Below is the code i use i need a check to see if column i is greater than 5, if it is then send the email if not do not send the email Sub Send_Bulk_Mails() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("sheet1") Dim i As Integer Dim OA As Object Dim msg As Object Set OA =...

Hi im looking for a vba code that will separate the client and applicant solicitors onto new workbook and save them atm i have to filter client sol copy and paste ona new sheet then filter app sol then copy paste that on a new sheet , i need all Test law to go onto a new workbook from applicant...

Hi Everyone,I followed a youtube tutorial to copy data from one sheet into another sheet in the same workbook. Mind you, I have no experience in VBA. Everything was working fine until I noticed that when i add a new entry it overwrites the previous row. I want the code to find the last empty row...

I hope someone can help me! I want that when I enter a value in cell B3 (or B4), the triangle in cell F3 (or J4) moves along. Likewise, when I enter a value in cell C3 (or C4), the triangle in cell J3 (or Q4) will also move. And how to program when I have many TASK to do. It's too hard for me...

Hello, I have a spreadsheet where I want to replace the contents of a cell with the contents of another cell based on a table. I've written a VBA code that'll work if the replacement content is less than 255 characters, but gives me an error is the replacement text is longer than that. Can...

I need help changing a piece of code that @JoeMo came up with on this forum. Private Sub Worksheet_Activate() Dim wSheet As Worksheet Dim n As Integer Dim calcState As Long, scrUpdateState As Long calcState = Application.Calculation Application.Calculation = xlCalculationManual scrUpdateState...

Hi everyone, I am wanting to set focus on the last entry in my listbox, after I have added to the database. Currently my listbox only displays when an entry has been made. The listbox shows the complete database which is fine, but I am wanting to set focus on the lastline as this is the...

Hello, I am looking to create two separate buttons using VBA and have not been able to successfully write a working code for either. I am trying to have both these buttons edit every Excel file in the same folder as the excel workbook containing the button and every sheet within each Excel...

I am looking to make a Macro in VBA that when run: creates a new sheet called "results" after the first sheet (to the right) on the original sheet search Colum B for if any of an array of words is present in a cell if it is to select the row and move it to the sheet called results delete the...

Hello, I need help to hide the column "O", but it can only be hidden IF it has the value "XYZ" in one of the cells of the column "K" AND if the cells of the column "M" has nothing or i.e. be different from 0. I tried this but it didn't work; Dim C As Range Dim ABC As Range Dim DEF As Range...

I have this code to click between two cells back and forth every minute for an hour but i'm trying to make it into two buttons so i can have it run continuously and click a stop button when needed. This code i've pasted gives the blue wheel and doesn't allow me to click anything with excel. Help...

I have a code that copies data from column C or E if there's no data on column C from all sheets on the workbook except the master sheet But this code is not completely mine, I asked a colleague help to make it for me What I know is that it also depends on column G Can someone please explain to...

Hello, Newbie in VBA here. The scenario is that I have files in .csv format, I run them though a Query and get the expected results. So far so good. I then want to copy the sheets from the current workbook to a new workbook with the same name but the .xlsx extension. I am able to extract the...

can someone make this code efficient This code is meant to compare the revision between two workbooks Sub Compare_Revision_MCC7021() 'makes sure the button is only pushed when it is meant to be. simple check on the tab either side to make sure its the lastest Rev, and not the first'...

I have a master file and a Data Folder that contains workbooks with the same format. I also have a VBA code inside the master file that is able to copy the first sheet of all the selected workbook Sub Merge_Files_First_Sheet_Only() 'Merges all files in a folder to a main file...

Hello everyone, I want to create a master file to consolidate 1 sheet from 10 different files. For example, the name of the sheet I want : FREE, the names of the different files : Europe / America / Africa. So I copy the sheet Free from Europe / America / Africa and paste them into one master...