module

  1. F

    Return Colum headers based on positive and negative cell value

    Hi For the last hour or so I have been trying to find an answer through youtube but just can't it. Really appreciate if some one can help me with this, I just created a table from randon figures which represent the actual table at work, so the modules are products and the dis module colum is...
  2. A

    VBA: 2 Subs in Same Module, but Cannot Run Them as Macro Box is Empty

    Hi, I'd really appreciate some help. I've written two Subs in a single module for Sheet 4. This module seems to compile fine. Both Subs are public. When I try to run this I get a window asking for the macro name, but there are no macros shown to choose from. I tortured myself looking online...
  3. J

    Reference variable between two modules

    I have two subroutines in the same module named: Sub JT() Sub TJ() in Sub TJ I want to use one of the variables I defined in sub JT()
  4. E

    Public Range

    Hello, I think it is a noob question but... How can I range a cell with a variable to a module? My code right now is pretty simple, this is on the actual sheet: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$7" Then Call Procurar End If End Sub...
  5. 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?
  6. azizrasul

    Keeping a dictionary in scope

    I have Dim MyDict As Dictionary at the top of a module so that it can be used by multiple functions. How do I enable the values in MyDict to remain in memory when I use MyDict.Add appAccess.currentproject.Name, appAccess so that I can use the values in MyDict in separate functions within...
  7. T

    Ignore shift on open

    I want to add a control so depsite the user holding down the shift ket, macros still run (assuming macros are enabled of course)! This article indeed does this: http://pixcels.nl/disable-shift-key-on-open/ However it mentions this code needs to be added in the Ribbon module: Sub...
  8. Caleeco

    Call Module Subroutine from SelectionChange Event

    Hello, I'm having a code structure issue, so the code below is just representative of the problem. I have several sheets which I would like to have a SelectionChange Event trigger some code to run. There is one routine that I have that needs to run regardless of which SelectionChange event...
  9. sharky12345

    Check if Module exists

    I'm trying to find a method to identify if a specific module exists in a project. I've tried this but it doesn't work - is there a simple solution? If ActiveWorkbook.VBProject.VBComponents("Setup") <> "" Then
  10. R

    Module, UserForm, & MultiPage Managment

    I'm working on a fairly large (for me) project, using one (main) UserForm with a MultiPage. I was working under the mistaken belief that, So most everything went into the UserForm Module. Things were going pretty well until I noticed the "fine print", Ummm... right. :roll: When I saw...
  11. R

    Excel crashing every time I open a userform on a workbook.

    This hasn't ever happened to me in the year I've been using this sheet. I applied some changes a few days ago and it was working fine. I applied some more changes yesterday and it was working fine. I also applied some changes an hour ago and it was working fine. I've now gone to use the...
  12. R

    Excel VBA - Concatenate Module for Multiple Lines

    Hi all. I am new to excel VBA and I am trying to create a module that will concatenate multiple lines. Here is an example of data from the excel workbook: Once the macro is executed, I would like the result to look like this: Any information would greatly appreciated. Thank you in...
  13. S

    Personal workbook macros and macro modules and macro calls

    Greetings, I have a macro that calls other macros. in past times I was able to run the parent macro and have the called macros work as intended. I am running into a problem now. For some reason I have macros in the 'macro' window titled as "PERSONAL.xls [then the module name].macro name"...
  14. D

    Active x control click issue

    I want to assign a macro to an active x command button. However the code is not in the sheet object, but rather in a module. What do I have to do for the code to run from the module? At the moment when the button is clicked, nothing happens. The reason I don't have the code in the worksheet...
  15. D

    Sharing an Excel VBA addin

    I have a VBA module that takes the contents of a spreadsheet in a specified format, re formats the data and writes the new format to a text file. The VBA module does what it is supposed to, but now i want to send it to someone who is non-technical. I need an easy way to install the...
  16. K

    Excel error message when trying to add an Add-In

    This is the error message: "Compile error in hidden module: mMenuAdd"
  17. J

    Personal Workbook

    I have some macros that I want to use with any spreadsheet so I put them in VBAProject (Personal macro Workbook). Everything was good. Then for some reason, a new project was added and a macro was moved. Here's the "before": VbaProject (Budget 3.xlsm) Microsoft Excel objects Sheet1-...
  18. G

    Identifying Time Overlaps

    I have a large data set that looks like this: <tbody> COURSE START TIME END TIME Conflict Module 2 28/01/2019 16:00 28/01/2019 18:00 TRUE Module 5 13/02/2019 09:00 13/02/2019 12:00 FALSE Module 6 10/10/2019 09:00 10/10/2019 17:00 FALSE Module 10 28/01/2019 16:00 28/01/2019 17:00...
  19. M

    Delete a module

    Can anyone provide me with the steps to delete this module off my form homepage in access...I'm receiving this error when it opens now but it won't let me delete module 5 nor do I know how...Right clicking won't work... error message when database opens to form homepage: undefined function...
  20. 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...

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