vba & code

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?

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...