module

  1. R

    Version control and modular design

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

    Calling a sub routine from a startup Sub

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

    Linking a Module to a Macro in Access

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

    Copy module VBA

    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?​
  5. L

    conversion module

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

    Can you set a variable for an entire module?

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

    accessing variant after macro has ended

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

    Macro Jump to other Public Functions which are not called

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

    Class Module Triggered by multiple Target.Cell(1).Addresses

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

    VBA Case Statement: Continous calculations

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

    Use variable from another sub

    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 =...
  12. J

    Copy module VBA

    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?
  13. G

    Find numbers in a string at a certain position

    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)...
  14. M

    Managing large personal.xlsb file

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

    Referring to a workbook opened in a different module

    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"...
  16. D

    a 100% working project it has 1 SUB that isn't included in the module's "macro browser"

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

    VBA - Entering The Date When Data is copy/pasted.

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

    run macro by pressing f5 is not working

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

    Calling a Variable from another Module

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

    VBA to disable a sub within a module from running

    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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top