visual basic

Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Sheet1.ShowAllData On Error GoTo 0 Dim fromRow% Dim archiveRow% Dim strMatch As String Dim wsTarget As Worksheet 'sheet to move data to Dim blnMove As Boolean 'whether to move data or not Dim...

Hello guys, How can I make excel send email reminders in outlook based on the given dates In one column. I would like to make it send the reminder with 6 months in advance, do you have any ideas? I have seen it is possible to do so with visual basic but I do not know how to code.

Hello everyone, I'm hoping someone can help me with a bit of dilemma. I have a long list of cases that I am working on. I have to be reminded on which ones to chase everyday. I have used conditional formatting where certain cases are coloured which kind of helps, but as the list gets longer...

Hello All, I have trouble running the following macro (See the attached image). Sub Translation() Dim fndList As Variant Dim rplcList As Variant Dim x As Long fndList = Array("Pound Sterling", "Outgoing amount ATM/Dispenser", "Banknote") rplcList = Array("Libra Esterlina", "Salida dotación...

Hello everyone! I want to apologize in advance if my language is not the most correct or if I am unable to explain what I wish to do in the best way, as I am a beginner at using Excel. I have attempted many google searches using different wording but unfortunately without success. Here is a...

Hi I can't XL2BB as my work won't allow it: I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then...

Hello, I do found a VB formula in order to extract a set of email addresses from Excel to an Outlook email draft, so email drafting will be way easier especially if we maintain a lot of distribution lists for different email communications. My problem is I want to implement this to a...

Hi everyone, I'm new to Visual Basic. For the past 2 days I've been trying to make functional an automatic code that should process multiple Excels and change one of the modules code from their respective Visual Basic projects. Each VB project is protected. I used this following code to...

Hello My code is set to wipe a workbook based on a date Private Sub Workbook_Open() Dim ws As Worksheet ' Check to see if specified date is passed If Date >= DateSerial(2023, 7, 6) Then ' If it is, loop through all sheets For Each ws In ActiveWorkbook.Worksheets '...

Hello New to this forum. Due to the legal need to delete data after 6 years, I need VBA code to do the following: - on X date - wipe all data from workbook, including all the sheets - delete version history (so it can’t be recovered) - if possible, replace with a message “data deleted -...

I've created and stored a workbook on a teams group for a number of users which contains formulae which link to another workbook I have saved separately, on a different teams group. I have tried to set the workbook to automatically update links but when other users, who are not that experienced...

Hello, I track the whole company's absence on a single excel tracker (excerpt below). At the end of each week, I am required to provide an individual absence report to managers in each location. There are currently 62 in the business across 8 locations and this is hours of work on a Friday. We...

Hi I need a VBA code to clear/reset all filters from all sheets upon workbook close. A number of users of a workbook are always leaving filtered criteria applied and exiting. With some sheets having 100 columns, it sometimes causes problems when others open the workbook and think data is...

Hello This is my sheet (unfortunately can't install XL2BB on my work machine): Sheet is called "outstanding" and is 16 columns wide. I already have VB code in here which moves the row to another sheet based on the status from a drop-down list in column O. When the workbook is opened (or...

Hello. I am trying to automate the following. I need to update Query 1, 2, 3, and 4 with a dealership ID #. So instead of opening up each query and entering the dealership ID #, I was wondering if there is an easier way of automating this. I used to use [Forms]![Form1]![dealerno] but this is not...

Hello, The below macro is assigned to a button on the ribbon and works on the "current 6 months" sheet. It looks down column B for "terminated" and deletes the row. It's currently restricted to only work on "current 6 months" sheet. Is there any way to add another sheet "Previous 6 months" to...

I have a 2D-Array and I want to look up for values in the column. arrDestination(0, i) = Name(i) (asdfg, csda, asdfg,zzz) arrDestination(1, i) = Values(i) (100, 50, 100, 60) My 2D Arrays contains the names and values. If my arrDestination Array match with Column A then I want to insert the...

I have been developing an API-based program using excel VBA because I can make user interface easily in excel worksheets. But the program is getting large and slow. My program calls millions of API function each run, up to 1 hour. The calling iteration seems to overhead the running time and it...

Hello, I have an absence tracker which records absence in a current 6-month rolling period and a previous 6-month rolling period. Each occasion of absence is recorded as a separate row and absence is manually added to the "current 6 month" sheet daily (as it occurs). A piece of VBA code then...

Hello, I use the below code for my absence tracker which was kindly provided on here. I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at: Current 6 months Tab - All absence in the last 6 month rolling period from...