vba

I'm in need of some help please and thank you. I have to submit a timesheet for work every week. It must be submitted by emailing a pdf of the completed timesheet (complete by hand then scan then email). In 2020, I re-created the timesheet into a spreadsheet and created a VBA macro so that a...

1. Is there a more efficient code than the code below, as I have to run it for each participant group i.e. 10 times and VBA won't allow it because it is too long? 2. Instead of the code starting to paste in column H as the dates will change frequently, can it look up the date in the upload tab...

Hello to everybody I have found the below very useful code from Contextures Excel Resources to Help You Succeed Option Explicit ' Developed by Contextures Inc. ' www.contextures.com Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String Dim newVal As...

I know we can get IAccessible of an object by first declaring a variable of type IAccessible and set it to the object we want the interface from, but that requires a reference to a TypeLib in VBE menu -> Tools ->References. Wondering if we can do that without reference and with API only. Ideally...

I've been trying to work this out and searching multiple sources and forums to no avail. MY APPLICATION: We are an engineering firm. I have a "Special" Workbook that peforms calcaultions that need to have Iterations=TRUE to get past Excel throwing up an error. There is not, in fact, a circuilar...

I'm trying to write some VBA code that will tell me if a row containing exact data exists. The table (Table1) is formatted as a table with headers, and has 20 columns; the first three columns are what I am concerned with right now. - Some projects will have multiple associated sites - Some...

I am writing a reusable VBA routine to copy data and formulas from one Excel workbook to another. I am working with large amounts of data and formulas and have found that copying by assigning values (Range2.Value2 = Range1.Value2 vs. Cut/Paste) has better performance. However, I can't figure out...

Hello all, Hoping to find some assistance with a pesky task. Each week, I run a report that produced a text file. This task is going to be handed off to other individuals with limited Excel experience and need to automate as much as possible. I have been successful in prompting the user to...

Hello, I have some pretty basic code that copies some data from workbook (ActiveWorkbook) to multiple named sheets in another named workbook. It checks to see if Cell A3 on the first sheet is blank and if it is, copies a bunch of data. One piece of data it copies is a specific number (between 1...

Hello everybody, I'm new here and also fairly new to Excel VBA. My problem is that I have two subs 'combined' in one sheet, but only one works. The first part of the code enables me to select more than one worker in column G from a drop down list and is working just fine atm. The goal of the...

Hi, I downloaded a excel file which uses VBA to change color of shapes as per values entered in Column A. However, the colour of shape 'M11' does not change based on cell value in reference 'A14'. The colour of all shapes change based on the value in cell A4 to A15. Can someone please help me...

Hey I need help on this: I first solved the proplem of showing the correct cities based on the what was selected in the first drop menu by using this formulas in data validation: (coutry and city are named ranges for countries and cities). IF($E$3="US",OFFSET(city, 0, 0, 2, 1),city) But the...

I would like to copy from Cells O4:O9 in Sheet 1. The destination would be a transposed paste result into A1:F1 in Sheet 2. I would like the information to remain their temporarily. Then, if I run the macro again, I would like it to copy the new data in O4:O9, but this time paste into A2:F2 on...

Hi, It's been a while I have posted a question here, but when I had this issue, first thing came to my mind was 'MrExcel.com' :) Anyways, I use outlook to search multiple items (invoices) and i make use of keywords. let's say I am looking for 3 items, 111236-2, 111235, 111321. Usually the list...

Hello, The below macro currently works perfectly and moves a line of data based on the selection from a drop-down menu (data validation list). I'd like to add a simple "are you sure you want to proceed" "yes" "no" style button message box when the user selects the item. Private Sub...

I have a 2 page spreadsheet that I would like to warn me, prior to printing to print 1 page as I need to take the printed page and flip it to print page 2 I tried the vba below, but I can't get past the warning to print page 1 as the message keeps coming back. Perhaps there is a different way...

A little bit of a strange one for me as I have experienced this issue before . I have a sub which is a file picker. This allows a user to navigate to a windows folder and select 1 or many text files and then import them into Excel. Excel is *supposed* to import all selected text files in to an...

Hello, I am currently working on with a user form which has multipage tool, and each page has different tools such textboxes, combo boxes and checkboxes. This user form will be use as a data entry tool which will be populated into specific columns once the user click submit. Whenever I try to...

I'm stumped on this one - I'm currently automating a file and I need the macro to select the most recent date slicer dynamically. My current code is selecting all of the dates listed in the slicer instead of the most recent date. Sub maxdateslicer() Sheets("FIP").Select...

Hi I am trying to do a sumproduct as a dynamic vba code but I cannot get it to work. I'd use XL2BB but i'm on a work computer so i can't install anything, so attaching picture for some clarity. This is for an order form and the reason i want it dynamic is because the number of rows changes...