modules

  1. M

    Size limit on Modules in VBA?

    I'm nearing the completion of a macro-enabled workbook that has many modules. I remember seeing some forum posts online that talked about there being a size limit to modules. It seems that the unofficial word is that the limit is 64K for each one. One post I saw suggested to type the...
  2. B

    What are Class Modules

    Hi, I am new to MS Access and have never used Class module in Excel VBA either. My question is more regarding Access, can anyone please help me understand what are class modules. How they are different from regular modules. What are the advantages of a class module or why and when should we...
  3. M

    Which is a better technique, More modules, few routines in each modules

    As I trying to get my coding better, I've been searching for advice regarding which is a better technique. More Modules, each with a unique name referring to the (perhaps) one to five related modules, or fewer modules with more routines in each module. I have figured out it's easier to have a...
  4. A

    VBA - Add In with Modules/Subroutines

    Hello, I am working with different tools based on workbooks at work. Now I don't want to write/update the code, which is over some workbooks the same, again and again in every tool. The solution should be to write this tool, which is exactly the same in every tool, in an add in, and connect...
  5. T

    Calculating % based on items filled in a column?

    Hi. Here's an example table below and the column I'm trying to count and calculate. Looking for some help... <tbody> A B C D E F Number of A Modules Number of B Modules Number of C Modules Number of D Modules Number of E Modules % of Penetration of all Modules 1 550 - -...
  6. T

    Personal.xlsb visible but not opening.

    Hi all. I hope you can help me as I am having a bad, bad day I was editing a long macro earlier in VB editor and when I returned to it, my macros have all disappeared. The PERSONAL.XLSB file is still visible in C:\Users\tt*******\AppData\Roaming\Microsoft\Excel\XLSTART which I hope is a...
  7. dispelthemyth

    Extracting modules from a different workbook via VBA? (corrupt file)

    I have a corrupt file that i cant expand the project view on meaning i cant get to the point of seeing the modules and right clicking to export (it is password protecting and i am able to enter the password successfully) Is there a way to export these modules using VBA when inside another workbook?
  8. N

    Can Userform, Modules and Class Modules of Excel be exported to Word ? with all the sub routines written in Userform, Modules and class modules

    Hello Before implementing i thought of asking the following Can Userform, Modules and Class Modules of Excel be exported to Word ? with all the sub routines written in Userform, Modules and class Modules of Excel using Excel 2013 Thanks and Regards NimishK
  9. H

    Module Usage

    Hi - I have a general questions about whether it's best to put all your code into 1 macro, or create separate modules for each procedure and then call them? thanks!
  10. J

    VBA Updae Cell References

    Hi, I'm sure this will be a dumb question because I'm sure I already know the answer. I have written a dozen modules of code in a spreadsheet and now the main sheet used needs to be edited slightly. This means inserting 6 rows to it so all my code references are now out by 6 rows. I don't...
  11. D

    How do I move code from sheets to modules?

    At the moment, all my code is stored in two sheets and I want organise my code a little better by moving some of it into modules. I don't know how to move it to modules and have it still work, for instance, have the command button still run the code when it is clicked. How do I do this?
  12. H

    Multiple Modules?

    I have like 15 Modules in my workbook, I have no idea why 14 of them are there. I don't know that much about VBA so I don't know if they are needed. I do have a bunch of buttons connected to macros. Is this a glitch?
  13. T

    List contents of modules in ListBox

    Howdy, How can I list in the ListBox or TextBox (in the UserForm) the modules from a .xlsm file In ListBox1, list the modules and in the ListBox2 or TextBox, the contents of the selected module in Listbox1. Is that possible? I have seen on Youtube or forums, that I can list the modules in a...
  14. H

    which module to use

    One of my workbooks has become corrupted, I printed all the vba, and now I have to retype it all, do I need to put each back into the modules or can I just write each sub one after each other in one module?
  15. JenniferMurphy

    Add-In modules vs Code Modules

    Is there a way to have an add-in module deactivated for one workbook, but still active for all other workbooks? The only way I know of to deactivate an add-in is File | Options | Add-Ins | Manage | uncheck the add-in in the list. This procedure causes that add-in to unchecked for all workbooks...
  16. rhino4eva

    option explict

    Option Explicit Dim fileloc As Long fileloc = "G:\Infection Control\CDRNE\CDRN Prism Data\MLVA data\IC RAW EXPORT TABLE" I want t use this fileloc string in several subsequent modules but I get an error message Compile error Invalid outside procedure Any ideas please
  17. A

    Macro Location Control

    I have a number of spreadsheets with many macros, one in particular with nearly 400. Whilst the sheet and the macros work fine, when I edit macros I note that the later ones are "saved" in separate modules. My tidy mind says that it would be neater and easier to search and edit if they were all...
  18. P

    How do you make functions available to all modules

    Hello... Here's a simple function I use in a lot of different programs. I normally just paste it into each module but it occurs to me there should be a way to paste it a single time and make it available to all the modules. 'Get Folder Function Get_Folder() Dim Folder_x As String...
  19. Dan Wilson

    Macro help

    Good day. I am running Excel out of Office 365 on Windows 10. I was working in the Developer function editing a macro. Normally, on the left side of the screen is a list off all the available Modules. I tried to hide some modules with a number higher than 9 because the list was sorting 1...
  20. M

    Can I overwrite an existing BAS files when importing modules?

    My current code simply adds a 1 to the module's names, just wondering if there's a replace command I could use or some other method, Thanks Sub Import_basFiles() Dim StrFile As String StrFile = Dir("C:\users\steve\desktop\basfiles\") Do While Len(StrFile) > 0...

Some videos you may like

This Week's Hot Topics

Top