visual basic

Hello, @Petertenthije kindly provided the below code for my absence tracker on 13 August 2022. On the "current 12 months" tab, is held all absences within the current 12 month rolling period. The code will then activate upon opening the workbook and move any rows with an absence start date of...

Hello, Really silly question but I have no idea how to do this: I need to add these two: Me.Protect Password:="zzz" Me.Unprotect Password:="zzz" Into the below, so I can get the below to work on a protected workbook. The ZZZ I will amend to the protection password later but it basically...

Hello, The code below is not working properly: I can't understand how this is happening, as I have another workbook laid out the same with exactly the same code in it and it works perfectly. I'm not an advanced user at all, someone on here kindly put it together for me, so I have no idea how...

Hello everyone, I inserted several ActiveX combo boxes in a sheet, I figured out a way to reset those combo boxes with a macro button, the thing is that I thought I was only reseting one but instead I was reseting them all (which I don't want) I checked what was I doing wrong and in the code...

Hello, I have the below piece of code which moves a row of data to another sheet within the workbook, based on the value from a data validation list. The code works perfectly. However, the sheet it moves the data from has a lot of formulas in it and people who use the sheet keep accidentally...

Hello everyone, Is there a way to populate an activeX combo box with a dynamic range (this means we can add and remove values) that is located in a different sheet, Also that the combo box is capable of refreshing automatically whenever we add or remove values and ignore blanks. If you could...

Hello I have the below code which moves a row of data to another sheet based on a value selected from a list. When the list item is selected, I'd like the row to be moved to the "LTS" sheet with all conditional formatting removed. Is this possible? Private Sub Worksheet_Change(ByVal Target...

Hi All, I know this is not necessarily Excel-related, however, it is going to be VBA related. I have created a return-to-work form in word, which is sent to managers to complete return-to-work interviews for sick employees. The document is restricted and only form fields can be completed...

Hi there, I'm new to visual basics and I'm trying to filter my data so it will show up as the User searches for it. However, I want the User to be able to search for partial matches. Example: Product Number in the table is 1234567 I want the User to be able to simply search for...

Hi, I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes. The sort of thing I’m after...

Hello everyone! I create Userform with this tutorial: Fully Automated Data Entry Userform - TheDataLabs Here is main code: Option Explicit Sub Reset() Dim iRow As Long iRow = [Counta(Database!A:A)] ' idetifying the last row With frmForm .txtNR.Value =...

Hi All, I'm trying to find the best way to add an additional row that tells me when the "Exclusion status" column is rejected. Unfortunately, I don't have this data and I need to add this in, but I'm totally failing at this. All I want to do is to add a row below each "Indicator" (column B)...

Hello all, I'm new to this forum, but I feel like this is a great place to get help. I am trying to find the correct If Then coding to use that will pop up a message box if there is no inverse to a matrix, but everything I have tried has failed. The closest I have gotten to something that works...

I have rudimentary VBA experience, but I have a specific problem which I need VBA to solve. Here is my best attempt at explaining what I need VBA to do (with some context): Context on How the Spreadsheet Works I have a worksheet called 'Block Chain' which logs a large amount of data for a...

I have the following code. Within the range B4-P4 are the days of the week (Monday-Sunday) and I'm trying to limit the characters so that it will say (Mon-Sun). I'm not sure if .Left is the right property to use so if anyone has any other ideas, please offer them! With Range("B4:P4")...

Hi, Thank you for reading this post. I need your help. I have some data an excel.. let's say column A has clients name and column B has clients email address. Column C sales figures. What I want is that I want to use excel macro so that 1) I can send email to each clients individually. 2)...

Hi, Can someone help me? I don't know how to solve this problem: find the product of a series from i=1 to n, where X(i)= b -(n- i )* (r) and r=( (X(n)-X(1)))/n Lets suppose that n=25 and b=2, X(1)= 0,1472, X(25)=2 and r=0,772 Can someone show us the easiest way how to solve for product of a...

Hello. I have a macro which is working great thus far. My last step is...copying sheet1 contents from one workbook to another workbook. Both workbooks are open and are named properly based on a script. Variables are being used to name the xls files since the VB loops and the filenames are...

So I'm taking a civil engineering course and the teacher is teaching us some coding. Not getting deep into the subject of the class, i'm trying to run this code but I keep getting a "Duplicate declaration in current scope" and keep getting the first line of the code in yellow. I don't know how...

Here is the scenario. When I create a new Job File, I need to add 2 specific sheets (Work and Detail) to this new job file. These sheets are in the quote file (Quote Number). The options for the Quote and specific sheets are in dropdown menu’s, however I need to select from 2 dropdown menus to...