module

Hi, I have a number of functions to calculate financial periods, rates, target dates etc. which I have in a single .bas file. These functions are used by a dozen macros and various users. My issue is that if I need to change a function, I have to replace the module in each of the macros and...

It seems that a Public variable declared in one module is available in others as well. But what about assigning the value to the variable in one module to be made available in others. Public InitialPart As String 'Module 1 Sub UserInput() InitialPart = "This is the initial part" End Sub...

I need a help with the following: A1 to h1 will have a default value of either 1 or blank ( this indicates the number of attempts the student makes for the exam ) Now in Cell J1 I want the response "module repeated" if any of the values from A1 to H1 is changed from 1 to 2 or 3 or 4 etc...

I have a formula in a Module that I want to assign to Column H. This formula determines if the training date is past Today() and will either display Not Qualified or Fully Qualified. Column H is dynamic based on the amount of training required for the job selected. I currently have it housed in...

I wrote a VBA macro to manipulate some data in a tab with a module in my Personal Workbook. Everything works great and fast. Now I'd like distribute this to my team, so I do my normal steps: Create a macro-enabled workbook. This is completely empty. Add a module. Paste the exact code from...

Sub TryOpenFileOpenFolder() Dim FileNameRef1 As String, FileNameRef2 As String, myPath As String FileNameRef1 = Application.WorksheetFunction.Text(Range("A1"), "General") FileNameRef2 = Application.WorksheetFunction.Text(Range("J1"), "General") myPath =...

Hi I am very new in VBA and making it with the help of some friends with limited knowledge on this subject. Expecting any help from forum members to solve this. As a part of my project I have created a code to copy a Hidden sheet "Sheet1" from "Workbook19" to new work book and save it as "New...

I would like to know where I can get help within the VBA module, If I cannot remember some of the VBA code names

Hello fellow VBAers, I hope someone out there can help me. Recently, I created a small tool/exercise/pedagogical game which works well for me but acts strangely for colleagues. The tool calls a recording (a .wav file) via a Function, the code for which I copied from a forum: Private Declare...

There are some of the Subs that when I call them from the standard module with my userform, I get errors so I have to place them in the userform module. I have not used the class module before. Can someone point out to me whether I am doing the right thing or not? Regards Kelly

I am looking for vba to prevent workbook_open from executing in new save as file without changing the original file. I have a template that I open with a workbook_Open module to auto generate a sequential number. I want to save the new file to a different location with a new name but I dont...

Anyone know how to copy a module that is in the personal.xls into another module also in the personal.xls? I have some code i want to take and modify it and make a new version hence the desire to copy code module A (in personal.xls) into a module B in the personal.xls.

Hello everyone, I am completely stumped on a solution and looking for some guidance. I have written code that among other things, adds a new sheet to a workbook. The workbook in question has a dropdown via data validation, which requires a worksheet change handler in the sheet module. I have...

Hello, I am trying to use VBA to Export the Module from a Personal Macro Workbook and Import that file into the Active Workbook. I have seen a few that work when it is workbook to workbook but I cannot get them to work from PMW. I am just needing some help. Thank you :) I didn't put any code...

I have some workbooks that friends or family members have asked for. Most of them make use of UDFs that are in my personal add-in module. I don't want to give them the entire add-in module for several reasons. What's the best way to make these workbooks transportable? If I copy the UDFs to a...

I am studying the stop watch example shown on this page and trying to incorporate it into a spreadsheet: https://trumpexcel.com/stopwatch-in-excel/ The demo has 3 key functions: one to start the stopwatch, one to stop it, and one to reset it (NOTE: color formatting code and other unnecessary...

I have a personal add-in module that I have used for years. It is called zzz add-ins.xlam and is stored, along with a couple of other add-in modules, here: C:\Documents and Settings\Administrator\Application Data\Microsoft\AddIns It contains dozens of UDFs that I have written over the years and...

Hi, Is it possible to change the font in the vba module? I wanted to see apl thanks

Hi All, I have a radio button on sheet1 module 1 called (Sec1No). this is the code : Sub Sec1No MsgBox "blah" End Sub Then I have a radio button on sheet2 module2. Is it possible that when the user clicks on the first radio button sheet 1 to then automatically check the radio button on...

I have a work book with 2 worksheets. 1 Worksheet is my raw data. My Second Worksheet is Essentially a form that gets printed to fill out facility condition indexes for an entire campus. I have everything else on my form completed to include when a row of the raw data gets updated, it will time...