module

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

    Run-time error 438. Object doesn't support this property or method.

    Hello. I was unable to find any leads on this by searching. I have a workbook with a sheet containing several combo boxes. The combo boxes are populated by code in the This Workbook module when the file opens. Some people can open the workbook without problems. Some other people get a...
  4. S

    Dynamic unique lists

    Hi all I am trying to create a series of dynamic lists with data from a table searching on 1 criteria to return a second set of data Example data set Make Item 200mm ICP module 300mm DEP module 200mm DSiv module 200mm DEP module 300mm Synapse module 200mm DEP...
  5. H

    VBA code for undo

    Hi, I am looking for a vba code for my module which will undo my works. thank you
  6. L

    new module for recording macros

    Hi I inserted a module and wrote a macro there. Then went to excel and recorded a macro. I went back to VB editor and found that excel inserted a new module and put recorded macros in that module and my first module was not touch. Now when I record any macro, the new recorded macro will go to...
  7. A

    Error 91: Object variable or With block variable not set

    I keep getting the aforementioned error. I have a module (modGlobals) which I use for all public variables... Below seems to be the offending Sub which is in a module. This code is used to populate a list box from entries on a spreadsheet. Sub GetList() If Right(frmMain.Caption, 3) = "V&V"...
  8. D

    For each cntl trigger class module

    Hi I've dynamically created a number of textboxes on a userform. Each textbox was added to a class module with some associated attributes. I also have a number of option buttons to the side of the userform. By clicking the textbox, i can update the text in the textbox from the asociated...
  9. mikecox39

    UDF question: from Chapter 4 VBA and Macros text.

    I'm studying Jelen's book "VBA and Macros" and at the start of Chapter 4, on UDF's, he directs the reader to open a new module in the the VBA Editor and type the following function into the module: Add (Number1,Number2). Can someone tell me what I'm doing wrong because when I enter that line I...
  10. B

    Select a sheet by double-clicking

    Hello, I have a huge workbook with several tabs. I would like to be able to select the tab called "Main" by simply double-clicking anywhere in the spreadsheet. I tried with the code below (ThisWorkbook module) but it does not work :cool: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As...
  11. 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!
  12. J

    find and replace text within a known module

    Hey all!! I have a form that opens when I open a workbook. I use the form to open another workbook via a drop down list. I use Select Case to open the chosen option. What I'm looking to do is change wording in a module in the first opened workbook. How would I use the Find..Replace method and...
  13. A

    Public Variables -Can They be Referred to by Subs in Multiple Modules?

    I had hoped to be able to declare a variable as public in one module, assign a value to it then refer to it in other modules but as soon as I try to use it in a different module I'm getting "Compile error: Ambiguous name detected" Module 1 Highlights Public Var_DRPS_Code_Version As Variant...
  14. D

    VBA Code to force uppercase text in multiple textboxes

    Hello, I am new to excel an I was hoping to get some help. I have created a userform with multiple text boxes, I would like to force the entered text to Upper case. I currently am using a ucase syntax, but it looks rookie and slows my code down This is what I have so far. Private Sub...
  15. N

    Variable in VBA7

    Hello, I share a lot of generic code between my projects I load a module and it "speaks" immediately with other modules, enum's and type's... sometimes some specific module/enum/type is not on the workbook and I need to comment out a lots of line of code, so I thought to use some kind of...
  16. J

    Excel Book Login and PW question

    Does anyone have any tips on the best way's to protect your workbook with a Login? Maybe an up front Form and Module? Thank you for any help... Johnzea
  17. J

    Pivot table filter reference from cell value

    Hello. I asked a question yesterday in a thread that was from August of 2013: https://www.mrexcel.com/forum/excel-questions/625300-pivot-table-filter-reference-cell-2.html I'd like to ask the same question here in a new post. I used versions of the following code. Code in the Sheet Code...
  18. R

    [VBA] RE GetOpenFileName, I want to point Excel to a file, and then reference that in other modules

    Hi all, Doing a new sheet for reporting, I want to report on a campaign. Let's say our campaign is called "70. London" I use GetOpenFilename to point Excel to this, and then reference that file as 'facml' So now when I talk about facml in that module, it knows the file name and location, so...
  19. C

    VBA Module to automatically work in every excel file

    Hi, I have the following Excel Module that creates a new formula called Findword, Currently I have to press Alt + F11 and add it as a new module everytime I open up a new workbook, is there a way to save it in the background so it can automatically be used in every workbook <code class="vb...
  20. S

    vba code to copy a module

    Is there a way to get a line of code that will copy a module? Idea here being that if I had a line of code that failed, I could have that module copied into a text file, saved in a temporary folder, emailed (with the text file attached), and then the recipient might be able to fix it. I know how...

Some videos you may like

This Week's Hot Topics

Top