vba & code

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 All, desperate for help. I have a scenario that I'd really appreciate a piece of VBA code to run. I have a table of information in sheet 1. It runs across the rows. Based on the data in the Score column (Column B) and the Age in the Age column (Column C). I would like the code to select...

Hi VBA Developers, Hope you are fine, Please note I have been trying to create a database but in this case, I only need a column with the data, based on some parameters but during the process I am confused since the code I think should have some loops. Probably my code is a mess, but...

Hi; I have a login form where the password is displayed with * How can I display the password using the checkbox?

This is some (poor) vba code I wrote in order to take multirow information and unpivot it for a table that will be used elsewhere. I know unpivoting can be done in power pivot or even just in excel, but in my situation, having a macro run this code would be a whole hell of a lot easier. Thank...

Sub macGL_Detail_ImportAndFormat() ' ' macGL_Detail_ImportAndFormat() Macro ' Dim fileLocation As String Dim fileToOpen As Workbook Application.ScreenUpdating = False fileLocation = "\\company.corp\files\KDrive\DM Monthly Close\2024\04 2024\GL Detail\04 DVH Detail.xlsx" 'I would love to be...

Hello experts, I do have excel files (1 sheet per file but headers are different) to download everyday. I need to transfer them into a masterfile (grouped into sheets) then the process will repeat the next day but the masterfile is still the same. Basically the new values will be pasted to the...

Hi! I'm a complete begginer, so i don't know much about coding. I'm trying to create a button to run a macro that does the following: 1.- Save sheet2 in a specific location as PDF and saves the hyperlink in sheet24 of the active workbook in column 11 2.- Save a copy of some of the sheets of the...

Hi Team, We have a requirement to create multiple workbooks containing one-line questions and answers to share with our internal supplier team. We are looking for a fast and efficient way to generate these workbooks. Can anyone provide guidance or suggest techniques to streamline this process...

Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...

the cells have a number associated with it which looks something like this ,column A & B will never have any color the columns and rows are dynamic the Output is expected something like the below. the green columns B-C should only be populated when the whole line is green and only first...

Hi Everyone, I have an online appointment scheduler, using "https://www.squarespace.com/acuityscheduling". So far I have been manually copying all of the client information manually. Below is the information I gather manually from the website and put in my excel sheet. Is there a way I can...

Hi there I would like to know how I can set the following type of invoice numbers to be recorded on a different sheet by the use of a button form control and how I can use another button form control to automatically generate the next invoice number when I press the button as the sequence...

Hi all, I'm trying to automate the filling of a word template contract and I keep getting the 462 run-time error. The debug gives me the error colored in red below. I'm hoping for some directions on how to correct my code. I've tried couple of things already but nothing seems to be working...

While the saving box appears there is a cancel button at the bottom right corner. I want to prevent this button from appearing or prevent the saving box to appear all together. Essentially I don't want the user to cancel the save process. Please see the screenshot. Thank you!

Hi, I have a VBA project. There are two Userforms. On the first Userform, I chose some of them to be enabled and input a value in the respective text box. Then when I press the Next Button, it should control which Labels are enabled and which respective Text boxes have value so it should copy...

Thanks for reading! As show above, I need to create multiple (activex) buttons each hiding or showing a specific range of rows on another page but am struggling to find a solution. I have messed with this a little in the past but found my answers online and modified them to suit my needs. Here...

Hi to all I have two almost the same codes but for different ranges. Separately they working perfect, but If I combine them, only one working, in range ("F25:F50") and NOT for range ("E12:E24"). How to combine them correctly ? Joe4 it's your code, maybe you can help me again ? :) Thanks...

Hey all, Hope you can help me with the below challenge I face: I've got several folders with a lot of subfolders each, containing images (large majority is JPG, but there might be a few JPEGs, PNGs... ). Several users upload new images there all the time. So I am trying to get VBA to help me...

Hi; How can I enable and disable multiple text boxes using the combo box option button?