Hello everyone. I am using Windows 10 and Excel 2019. This is my first post here and I hope to learn and maybe, in time, give back. I use the code below to. 1. Clear all cell contents and formatting 2. Adds the text (value?) for cells A1 to AI 3. Fomats the cells 4. Freezes the top row. It seems to be a lot of code to do what appears to be something simple. My question is, is there a more simple or efficient way of writing the VBA code? Many thanks Code: Sub TestAddHeader()     With Application         .ScreenUpdating = False         ..read more

I am new at this forum :hi ..read more

Hello! Im quite new to using VBA in excel and while trying to make a macro to one of my workbook, ive encountered an error i cant figure out how to get past. I've taken inspiration from Excelforfreelancers inventory management system, and modified the code to fit my needs, but it returns with an compile error: Invalid or unqualified reference, highlighting the issue to be "Sub Menu_select" I confess i dont 100% understand the scope of this function, as every macro i use is more or less just recorded with the exception of a few, so this has left me a little confused. Any help/explanation of ..read more

I need a function (F) that calculates the table I uploaded based on the data. After that, you need a function (G) which calculates, given a given liquidity buffer, which one on which day the investor exits the deal, and what is his profit. This function has 2 inputs there are: the table created with the previous function and the size of the liquidity buffer. The function should check which is the first day on which the liquidity buffer and is the amount of the initial deposit is less in absolute value than the accumulated cash flow (last part of the table). column). If this day is t. day, then ..read more

I have a general question on accessing recordsets My VBA creates a recordset in module1. I purposefully did not close the connection or the recordset. I would like to be able to re-use the recordset in a couple of different modules (say 2 and 3). Is this even possible? Im looking for any sites, literature, etc that can help. Any direction you can give is greatly appreciated. Thanks in advance. -Chunk ..read more

I have a Word document (attached) where the user is to enter information about the status of several tasks. For each task the user is to select the status of the task from a content control dropdown list. Options are: "No issues" or "Issues found". If "Issues found" is selected, the user is to provide a description of the issue for that task in a textbox. While the code works for the first task, it does not work for the content controls in the second task What am I doing wrong? Code: Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean)   If CCtrl ..read more

Hello! I know this question may seem a bit silly, but I'm starting in the world of VBA and I don't know many things, I saw that this forum was active and that's why I ask here :) I'm doing something similar to a Game Show, where on slide 1 they ask for the name of the contestants and I wanted the Shapes of all the slides to show the given name. I saw that many people said that I could do a For cycle and go through all the slides changing the Shapes texts one by one, but it's not efficient when you have more than 100 questions ;-; Is there any way to make the text of all Shapes always be ..read more

Hi all, Got this today when coming to the site ..read more

Looking for a one night partner. No continuation. Actual Women Top-notch Сasual Dating ..read more

Hello, I am trying to create a function in VBA and I seem to be a bit stuck. I have created 5 subsets an they all work fine. What I then want to do is calculate the standard deviation of my subsets and take the average standard deviation. But my formula for standard deviation (in red) seems to not produce any results. I have tried searching and cannot find a solution anywhere. I have checked that my subsets contains only numerical values. Code detailed below:. Have i defined something incorrectly? Code: Function FITVol(rng As Range) As Double     Dim subsets(1 To 5) As Variant &nb ..read more