call

  1. gravanoc

    Using Application.Run to call macro from Personal Macro Workbook

    I want to run a macro in my Personal Macro Workbook from another workbook. I have not been successful. I believe that this is the required syntax: Sub Caller() Dim rngA As Range Set rngA = Selection ' The next line works when calling a macro in a workbook other than...
  2. H

    Private Sub Worksheet_Change(ByVal Target As Range) Not working

    Hi, I am trying to trigger Macros according to the value cell A2 of Sheet1 is changed to. After changing the value in A2 nothing seems to be happening. What am I missing? Cell A2 is merged with everything up to cell B7, but I have also tried without the cell being merged. Private Sub...
  3. D

    VBA Conditional Calling Based on Current Date

    Hello, I have a few different functions that are set up to do different things depending on the current date. List of functions: 2020_Tasks 2021_Tasks 2022_Tasks Is there a way, using VBA, to only call the '2020_Tasks' function if the current year is 2020, and then to continue moving through...
  4. S

    Count unless text is in a list

    In this scenario I am trying to track how many calls a staff member made in Jan. The catch is there are some calls that are not eligable for tracking. The ineligable call statuses are in a list. Is there a way to do this? I'm not great with excel, any help is appreciated! Count if the 'month'...
  5. T

    Call Command Looks For Sheet & If Not found End Sub

    Hi all, I am after some help, I use the following code to call a sheet and then produce it as a PDF, then it sets up the email ready to send - this is setup for 200 sheets and rather than make the button call up on active sheets where I have not used ' to negate the call. Is there a way of...
  6. H

    Excel VBA GetFolder from 2 Drive (2 location)

    I had a code which work very well for 1 location (path) Possible to open and run 2 location? Sub GetFolder() Range("A:L").ClearContents Range("A1").Value = "Name" Range("B1").Value = "ParentFolder" Range("A1").Select Dim strPath As String strPath = "K:\VIEWING" 'strPath(0) =...
  7. M

    How to count all rows between multiple ranges that repeat in sheet

    I would like help in trying to come up with a way (Excel VBA?) that will count the number of calls received each day. The report has all of the data in Column A but has months of data separated by text as shown below. I'm wondering if I could create a range between each "Call Date:xx/xx/xxxx"...
  8. T

    Passing arguments in a loop

    Instead of writing this: Option Explicit Sub Calling() Call Module1.Called(somearg:=1) Call Module1.Called(somearg:=2) Call Module1.Called(somearg:=3) End Sub Sub Called(ByRef somearg As Integer) somearg = somearg + 1 End Sub I would like to use...
  9. D

    Selection from drop down box

    I have a drop down box on a sheet called Start_here with 2 options and each option is a town. When the option is selected and a Continue button is pressed I need a header and footer to be loaded onto the sheet quote_sheet depending on the town selected. The headers and footers are images...
  10. L

    Losing my mind over "call" macro

    Hello all. I have a macro that hides and unhides several rows on a sheet, and works perfectly when on I use a button ON THAT SHEET. I have another sheet that has a checkbox that when selected, should run the exact same macro and for some reason it only runs half of it. I'm losing my mind, can...
  11. C

    Googled but cannot find - Automate a "Run All" button

    Greetings Folks, I have tried to figure this out but I've yet to come across something that will allow me to make this happen. Every morning I have to open an Access File and press the "Run All" button which will do the macro that's found in the "Code" area. Is there a way that I can setup...
  12. A

    VBA stops in middle of SQL routine

    Hi, I have VBA routine that calls several sub routines. The subroutines link to oracle and execute .sql scripts. When I run the sub routines individually they run fine, however, when I run the call routine it stops running in the midst of a couple of the sub routines, specifically 'Call...
  13. A

    VBA stops in middle of SQL routine

    Hi, I have VBA routine that calls several sub routines. The subroutines link to oracle and execute .sql scripts. When I run the sub routines individually they run fine, however, when I run the call routine it stops running in the midst of a couple of the sub routines, specifically 'Call...
  14. ExcelNovice

    Running multiple macros with one command button on userform

    Hi, I'm trying to run the following macros from a userform but continues to get an error each time I try: Private Sub CommandButton1_click() Call Worksheets("Sheet1").CommandButton11_click Call Worksheets("Sheet1").CommandButton12_click Call Worksheets("Sheet1").CommandButton13_click Call...
  15. N

    Passing Text Box value to another Text Box

    Hello, I have an inquiry in a userform, if you may help me I have the following textboxes that calculate some values txtAmount has a calculation which I have the code for it and all the below text boxes as well, unless the "txtPaid" I need "txtPaid" to be the same as the "txtTotal" but to be...
  16. L

    User forms and keeping array variables

    Hello, I am making a user form and I'd like it to contain: a drop down list, and 4 labels + 4 text boxes. The idea is after a choice is made in drop down list, 4 label values are changed depending on array position, and 4 text boxes can update the values of the array. So i fill up my array...
  17. J

    Call Center Occupancy

    Hello, I know that calls and AHT are needed to compute for the occupancy. But just wondering if occupancy can also be computed with just staffing requirement and net schedule staffed? Thanks, Jangjang;)
  18. D

    Adding a waiting 3D animated icon to code

    Hello all, My code is working as intended. There is a long waiting period as a consequence of the code run that I would like to call a 3D animated model I have to just run onscreen while the code is running in the background. I cannot figure out how to call it from VBA to appear as this...
  19. R

    Populate then clear

    I'm trying to take a snapshot of600+ different options quotes using my brokerage's RTD API, but they limit meto 100 requests at any one time.<o:p></o:p> I have a Range of cells that theRTD formulas are pasted into then once values have been generated (each cell inrange is > 0) to delete the...
  20. J

    Pivot table calculation question

    I have a pivot table that looks like this Row Label Appointment Email Phone Call Joe 148 302 86 Kate 129 88 303 Ron 157 398 157 Paul...

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
Top