module

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

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()

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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