vba & code

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?

Hi I am not able to progress after getting output got cell J11. Looks like the loop isn't working. I am looking to get the month end dates in the row 11 from the start date to end date. Can any one please help me to resolve this?

Hi there, I am trying to write a VBA code in order to automate a PP to automatically update textboxes with excel data. The current approach is: Set Excel File Path: It defines the path to the Excel workbook from which the data will be read. Open Excel Application: It creates a new instance of...

Hello! I'm new to VBA, this is honestly my first time playing around in it, and I need some assistance. I have a group of cells on my excel sheet that I want to have copied and pasted into the email body, but everything I try comes up with nothing. :( Could anyone help? I also really need my...

Starting at A17 on Sheet 1 I have a row of data that I need the data from columns A,B,C,D and G (Column B is a specific ship date) copied to one of the ranges in sheet 2 that contain the 4 quaters of the year. The date in coulmn B determines which range of the quartely ranges it goes into. On...

Date Type Stock Price Quantity Amount VBA Correct 04-01-2024 Bought MINM 3,960 10 39,60 04-01-2024 Sold MINM 3,900 10 39,00 -0,60 -0,60 04-01-2024 Bought MINM 4,060 10 40,60 - 04-01-2024 Bought MINM 3,760 10 37,60 - 04-01-2024 Sold MINM 4,130 20 82,60 7,40 4,40...

Hello, I'm relatively new to macros and I have been trying to write a macro that will enable me to format phone numbers into (XXX) XXX-XXXX regardless of the manner or format the original phone number is. What stumps me is when there is an area code in the original phone number i.e. +1 440 299...

Hi, I am interested in writing a macro using VBA to loop through the file names within a folder and delete all files that are not named a specific file name. In the example below, I would like the macro to delete all files that are not named "Prepaid Maintenance.xlsx". So far, the only way I've...

Hello I am new to here and new to VBA, I have tried to make my code using some knowledge and chatGPT, however I have managed to updated only one row and please help me with the following problem. Sub FindAndCopy() Dim searchValue As Variant Dim targetWorkbook As Workbook Dim...

Hello, I'm super duper new to VBA coding with literally 0 past experience past this project I've been assigned at work. I basically need a code where the macro searches column D for cells >1 and then inserts rows according to the value in the cell while subtracting 1. So if a value is 2, 1 row...

Hi! I found this VBA code that helps me hide/show a specific range when selecting one or the other cell. However I would like to use this multiple times on different cells. For instance when selecting B35 hide row 36:38 and when selecting D35 showing row 36:38. When selecting B39 hide row 40:42...

Hi everyone, I have a password protected spreadsheet that I can easily group and ungroup while it is protected. I am wanting to create a button to easily do a bulk group and ungroup while the sheet is protected. I am happy to have 2 buttons (1. Group, 2. Ungroup) instead of just 1. Is this...

Hi, This is my first thread, so if there is anything I am doing wrong please feel free to let me know. I have a really simple VBA code to be able to scan a code bar, check it with an inventory list and copy the information in a 3rd sheet to control sells. I am trying to implement a simple code...

Good morning, I am not sure if the title does the question justice. If Columns A,B,D,E,F,G and H match BUT column C does not match, I need a way to split the total hours(Column H) worked each day across each unique area as the count in each area/divided by the sum of the total count by...

Hey, im new to vba coding and im trying to create an automated macro that constantly checks two cell values for my worksheet . Basically i want it to check cell A12 and if its equal and or less than 250 to update Cell C12 with the number 250 I had tried to do it like this with what i learned...