call a sub

I am busy on a VBA/ Excel project. Most of everything runs fine and I can step through the code as I debug. However, in the one click event, I call a sub named, Get_Consult. For some reason, this sub refuses to run. I added breaks inside the sub to step through the code, but although the call to...

Good morning, I have three separate VBA codes and I want it to run a specific sub depending on the option selected from a MSG box? My three options for the msg box: - WI - WI, H&D - H&D The user will select which one and then I want it to call the sub depending on the selection. Can this be...

Hello, So, with help of kind people here I was able to make most of my project work, but have hit the hopefully last bump. Basically, I have a worksheet that based on condition decides whether the issue should go after Quality, Logistics or Finances, and then generates an email to be just sent...

Hi Guys, Unsure if you are able to do this. Example 1. Macro - Sub Test 2. Macro - Sub Test2 Within macro "Test " I'm calling macro "Test2" and passing a variable. The called macro "Test2" does what it needs to do and once completed I need to pass variables back to the main macro "Test"...

Hi, I have module1 which when ran is supposed to: Set variable "template" Call 6 different Sub's with "template" as argument The 6 subs all work perfectly when ran individually but when I try to use the Call method to run them only the first one gets ran, the other 5 never get executed. All...

I have been trying to use a Call with a variable to access other functions in Excel vba. I can access the cell contents but cannot assign it. The compiler states an error "Expected: identifier". Any ideas or thoughts? Do While j < numberOfSections + 1 functionCall =...

I'm trying to use subroutine for Beforedoubleclick for all available sheets regardless of name or number and (Call Worksheet_BeforeDoubleClick) is giving me various kind of error and won't go to that subroutine. Please assist. Here's my code Sub Dosomething() Dim pSheet As Worksheet...

Hi all, I want to clear cell "I15" after 60 seconds. I will be calling this sub within another sub. Probably being stupid but can someone see why the following isn't working? The cell is being cleared instantly. Sub ClearTimer() Dim StartTime As Single StartTime = Timer Do While Timer -...

Hi everyone, I want to call a Sub, if there is change in a certain cell. With the following code, this works as lang as there is something in the cell. [CODE] Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("A1") Or Target = Range("A2") Then Call "Name of Sub" End...

Scenario: I have 3 subs inModule 1. Each one of thesesubs uses some but not all of 5 available variables. All Strings. Instead of pickingand choosing which variables to define in each of the 3 subs, I'd like tocreate 1 more sub in Module 2. This sub would be called at the start of each ofthe 3...

Scenario: I have 3 subs inModule 1. Each one of thesesubs uses some but not all of 5 available variables. All Strings. Instead of pickingand choosing which variables to define in each of the 3 subs, I'd like tocreate 1 more sub in Module 2. This sub would be called at the start of each ofthe 3...

Apparently this happens when a variable is not defined, but all mine are, as far as I can tell. Also, when debugging, the error appears on the End Sub line. That is, the macro (seems to) exit correctly, but as it exits I get the error msg. If the error box could be forced to not appear it would...

Hi All I hope you can help. I am getting the error Run Time Error 1004 AutoFilter method of Range class Failed When I run my code, the funny thing is It works perfectly by itself, but when I put it into the other code and call it, it gives the error Run Time Error 1004 AutoFilter method of...

Hello, I am trying to copy the source data into all reports file located in my folder and it is working as i expected. However, i have to choose the same source file every time the loop go through one excel report in the folder. Would someone please help me to modify the code so that i only...

Hi all - I have been recieving some help pertaining to finding empty rows. I got the code to work: Dim nLastrow, bFind As Range Dim ii As Integer For ii = 2 To 5 nLastrow = Cells(Rows.Count, 3).End(xlUp).Row Set bFind = ActiveSheet.Range("C5:" & "C" & nLastrow).Find(What:="B" & ii...

Hi Everyone, I'm trying to call a sub called ScaleAxes that sits in a module elsewhere. The ScaleAxes code is: Option Explicit Sub ScaleAxes() Worksheets("Dashboard").ChartObjects("Measure Chart").Activate With ActiveChart.Axes(xlCategory, xlPrimary) .MaximumScale = Sheets("Lists and...

I have a command button macro that is set up. in it i call a Sub from the workbook. When i run the macro by itself, it works just fine. The command button works just fine by itself as well, but once they are combined it ends up giving me an error. "Run-time error '9': Subscript out of range" the...

Hi everyone, I'm trying to call in the parent Workbook (test) a sub in another Workbook (test2). This sub is supposed to insert a new line the test2. That is where the code is originally located. If I run the code seperately it works fine. If I try to call it from test, it doesn't. Do you have...

I am trying to figure out how to combine 2 macros. The first macro allows me to select the file path I need, and the second macro will use the file path from the first macro and pull the worksheets from all files in the file path and combine them into 1 summary workbook. What is the best way to...

I am writing a sub that has 17 calls to different subs and functions. I broke it up in this way because it was easier to write smaller pieces since a lot of actions are repeated (e.g., copying and renaming worksheets) and it was easier to control the flow I diagrammed in advance. Some calls are...