module

Hi, I manage an area with quite a number of VBA workbooks floating around. Everyone seems to be editing these on the fly and creating more workbooks coding from scratch but steeling (copy paste) from other workbooks. Can someone please refer me to a process, body of knowledge or other that can...

I have created a Sub routine in the 'Workbook Open' section of the 'ThisWorkbook' object to open a custom dialog box when the Worksheet is open ("Do you want to generate a report?"). If the user selects yes the sub goes on to contain all the code needed to generate the report (still within this...

Hi, I am new to access and I would like to find out how to linka module to a macro so I don’t have the run the module through VB. The module is working fine but I can’t figure out how tolink this to either A macro so I can run it from the Database tools tab Assign it to a button on a...

Have a module in VBA Project. How can I quickly copy the whole module and create a new one with a different name. If I right click the module their is no copy option?​

Hi The article below from Microsoft did not explain really What is Conversion? What kind of class/object etc. I used object browser and it says it is Module and it has some functions inside like Cint and Val. I understood that these functions are VBA functions. I tried them and I can access...

I have a module that contains several subs. Each of the subs contain the variable below where the "period" is updated by 1 each month. So next month the 1019 would become 1119, then 1219.... Since each sub contains this variable you must update the "period" in every sub. Is there a way to...

I have a public variable declared in a Module, that's triggered by worksheet change event; My public variable ceases to exist after the Module subroutine completes. How do I preserve a Public variable in memory, for use later on? Is there a way? Basically want to be able to retrieve that...

Hello Experts Here is the situation. I have an excel file which already have bunch of macros including some Public Functions which are real Pain. I am using this excel to build a tool which gives output in an automated way. To do so, I added few worksheets to get user inputs and calculation...

Good day, I have a dashboard on a worksheet that has 50-60 numbers, when you click on any of those numbers a 30-day trend on a userform appears. In my excel vba naivety I inserted 50-60 userforms all with identical code to form the graph. Everything works but boy, what a waste! I have 50-60...

I have a Case statement running with a worksheet_change event. I noticed that anytime a change is done it go completely through the entire worksheet step by step through the module. The worksheet has 75k rows so it literally takes forever. Is there a way to make this procedure only do the...

Hello everyone, I believe this would be a very easy question for the experts here. I want to use variables from another sub/module. An example of the code in module 1 is below: Public pinit, uy_from, uy_to As Variant, ws As Worksheet Sub TC() pinit = InputBox("initials") uy_from =...

Have a module in VBA Project. How can I quickly copy the whole module and create a new one with a different name. If I right click the module their is no copy option?

Howdy everyone :) I was hoping to get some help with a situation I'm stuck with. I have an excel worksheet with data in one of the columns that looks like the following. I'm looking for an expression to find all data that has "Reads" less than 1000 (the highlighted values marked in bold)...

I've got 20 years of utilities, forms, classes, and other macros in my personal.xlsb file. It's over 1MB now and while I use some macros more than others I don't want to leave any out for when I need them. I know it's a big chunk of memory to load the file, even if particular modules aren't...

Hi The below module will open an .xlsx workbook within a given path directory. FYI, I have used Public Constants to give a value to theSource_Template_Folder_Path and Source_Template_Name Dim Template_name As String Template_name = Source_Template_Folder_Path & Source_Template_Name &".xlsx"...

I have a working project (a number of subs in 500+ lines of code in one module) but there is something weird. One of the subs is not displayed in the dialog that pops up when (tools ->macro -> macros). 1)I initially thought that the naming was a problem...

Hello, I have 1. A Module, Then Worksheet 1, and Worksheet 2. When the module runs, it transfers data with todays date - from worksheet1 to worksheet 2. I figured out all that yesterday. Today, in VBE - in Worksheet1 I have a code (I provided below), that each time a user hits 'enter' the...

Hi I am trying to run macro as per the instruction below. It did not work. I opened the module and click inside and then press f5 but did not work. but if I go to menu run-->run, it will work, also if i click on run icon > , it will work. What could be the issue? thank you ++++ Run a macro...

Hi, I need a little help if possible I am trying to retrieve a calculated variable from withinanother module, and use globally until the session of excel is closed. I need to pass a 1 or 0 back SubProductLookupBVC(ByVal control As IRibbonControl) Dim Common AsNew cCommon Dim InputCellAs Range...

Hi I would like to use a pop prompt to disable a particular sub within a module from running? The prompt would appear on opening of the workbook. If the user clicks "No" this would disable the sub from running. Is this possible to achieve? Many thanks