Using 1 Macro To Start Another

Jan 19, 2009

I have a macro, at the end of which I'd like it to jump to a second macro OR incorporate the second macro into the 1st. I've tried combining them in several different ways, but get an error 13 every time. So, basically, if I can't combine them into 1 macro, then perhaps I can get the 1st to automatically start the second. The 1st code is based on a previous solution (for a different problem!) I received from this forum

Here is the 1st

View 5 Replies


Run A Macro On Start Up

Feb 5, 2007

I want my system to run a macro automatically every time its turned on.

View 9 Replies View Related

Start Macro At Workbook Open

Nov 14, 2008

I found an outlook plugin that saves any incoming emails as text. It also has an option to run an exe or bat file on saveing the email to text. I have a macro in a worksheet that will process the email to a database and send out a response.

What I am trying to figure out is how to run the macro in the worksheet whenever an incoming email is saved. So I have the 2 components that I need, I just need to tie them together so that everything is automated.

Does anyone know how to achieve this? Can I use a batch file to open an excel workbook and run a macro? Or can I create a standalone macro (outside of excel) that can open the excel file and run the macro.

View 3 Replies View Related

Trigger Macro At The Start Of The Month

Feb 18, 2009

is possible to trigger a macro at the start of every month. I have a fairly simple bit of VBA, but just want it to execute on the 1st of every new month.

View 3 Replies View Related

Macro Start When Data In Another Workbook Changes

Jun 10, 2009

I am brand new to using macro in excel. I have a report that is generated every month (looks like sheet 1) and I use that data to create an analysis report (sheet 2). Each month forecast is replaced by actual for the month that just finished, I have tried to use macro recorder to make this more automated as every month I copy the forecast down and the actuals in and then readjust my totals and add in the now 12th months forecast, but I have had no luck.

View 10 Replies View Related

MACRO To Start All Sheets On Cell A2

Jul 3, 2009

I can't figure this out: I need a macro that will start all of the worksheets in a workbook (about 94) on cell A2.

View 2 Replies View Related

Start Macro On Change Cell Value

Feb 16, 2012

I would like to run a macro when the value of a certain cell changes.I found the following code:

Private Sub Worksheet_Change(ByVal Target As range)

If Not Intersect(range("A1"), Target) Is Nothing Then
MsgBox "A1 has changed"
End If

End Sub

Cell A1 contains a lookup function. When the value of this cell changes, I would like to run the code. This code runs only when I change it manually.

View 1 Replies View Related

Start Macro Based On Cell Value?

Nov 8, 2013


Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value = 4 Then


I am trying to create a script that will start a specific macro based on a cell value. I have a drop down menu with 16 options. so if cell A1 = 4 run one macro. if cell A1 = 6 run a different macro.

View 9 Replies View Related

Can I Pause And Then Start Recording Macro Again

Nov 17, 2006

I'm recording a Macro but I want to test certain section before I complete it, so can I pause the recording and then restart the recording again?

View 9 Replies View Related

Start Macro From Clicking In Cell

Oct 30, 2007

I have created a macro that autofilter values in sheet 2.

In sheet1 I have a cocpit of values from Sheet 2, 3, 4 and 5.

In the monitoring cells in Sheet1 I would like to doubleclick (or similar) in the cell where I have a value from ex sheet 2, and then trigger the macro which does the autofiltering.

View 9 Replies View Related

Macro: Start Automatically Write

Oct 1, 2009

In First Part
I Have R1 1 -17
R2 20-22
I Want When I Write R1 1-17 in cells {B1:C1}And R2 20-28 In Cells {B2:C2}
Start Automatically Write From 1-17 in Column E and 20-25 In Column F in The Same Manner You See in The Pic He Ignores F18,F19 And Start Counting From F20
And Then Color The Common Area Which {E18:F19}

And Make The Same With The Second Part The Pic Which {G1:I2}

View 9 Replies View Related

Start/Run/Call Macro From Another Application

Aug 27, 2006

I have a program that produces data while im working on it, i want to start an excel macro (excel app running in background) from a keyboard shortcut that imports the current data. I cant think of a workaround, letting the macro run on a timer isnt possible since i want to be able to decide when exactly it imports the data, without the need for alt-tabbing out of the program (since its an directX app so alt-tab takes time and is annoying).

View 7 Replies View Related

VBA Transpose Macro Ignoring Items That Start With 0

Apr 6, 2013

I have adapted some code and it works almost perfectly in that it transposes data for each item in column A and details in subsequent columns on the same row and puts that in column format with the item number repeated, however, it does not work when the item starts with a 0 for example:

Column A Column B Column C Column D
12345 a-100 Blue a-233

will result in:

Column A Column B
12345 a-100
12345 Blue
12345 a-233

But if the item is 02345 or 03445 the code below won't pick it ignores it and moves to the next item in the list. Also if in the example above, column B is blank but columns C, D, E, F etc are not, the code will also ignore the item and move to transpose the next items.

How would the code below need to be modified in order to address those two issues?

Sub test()
Dim a, b(), i As Long, ii As Long, iii As Long, n As Long
With Sheets("Sheet5")
With .Range("a1").CurrentRegion.Resize(.Cells.SpecialCells(11).Row)

[Code] .....

View 5 Replies View Related

Sendkeys Macro Will Not Start With Keyboard Shortcut

Aug 18, 2014

However, I have not been able to find a solution. I created 2 macros that work using the alt+F8 and enter option as well as the run from the macros menu method. Whenever I try to use the keyboard short cut eg. Ctrl+e it will either not do anything or pause and then select every cell. The codes are below:

Sub Macro5()
' Macro5 Macro


I have tried multiple letter options and have also tried many macros in a new workbook and I cannot get it to run with the keyboard shortcut.

View 10 Replies View Related

Macro To Insert Start And End Date In Planning?

Feb 26, 2014

I am looking forward to creating a macro that would fill in my planning as per a project name (Cell B11)

Then when I enter the start and end date (range C14:D20). The planning (G5:AH9) would be filled in automatically as per the format in the cell in A14:A20.

refer the attach file. I entered manually an example in for the project "example1". I entered the project "example3" in B11 and starting and end dates. After running the macro button, The row 7:7 should look like the row 23:23.

View 4 Replies View Related

Display The Macro Start/stop Recording

Oct 13, 2008

How can I make XL (2000) display the macro start/stop recording and relative/absolute box that used to appear whenever I started recording a macro?

Such an apparently simple issue, but I can't resolve it!

Somehow I lost this small box, and I know how to force it to display via customize, but it doesn’t seem to work the same (relative does not work as such) and the buttons or box disappear.

View 2 Replies View Related

Can A Macro Start From Wherever Cell The Active Cursor Is On

Apr 5, 2006

Can a macro start from wherever cell the active cursor is on? or
perhaps from the cell that the macro button is clicked?

What I am trying to do is copy the data from F(whatever) to whatever
the last empty cell is in the row holds the active cursor. Or I can
create buttons for the macro to run, and it could copy the information
in that particular row.

View 10 Replies View Related

Assign Macro At Start And End Time On One Button

Jun 9, 2013

I want to assign a macro of start time and end time on one button. I tried but its not working..

View 2 Replies View Related

Automatically Start Macro On Any Change To A Specified Range

Jan 19, 2008

Within range Sheet1!D4:D423, how can I have a macro called RestartClock start any time the Enter key is selected within a cell for that range?

View 7 Replies View Related

Floating Macro Button - Return To Start Sheet

Apr 23, 2012

I want to make a "return" button that follows the user from the start sheet to other sheets and acts as a "return to the start sheet" button. I tried just recording a macro and cut/pasting the button from one sheet to the next, but apparently when you do this the button name changes.

View 6 Replies View Related

Disable Macro After Saving With The Week Start Date

Apr 21, 2007

I am trying to code a macro call where in once the file is saved with the current week start date all the other macro's should be disabled. Since am having lot of data and report sheets which needs to be added and deleted in the run. It causes me problem when I try to open it again to view the results. For example I have a sheet named apple and another one applereport. I have made my code to delete apple since it is a data sheet. I want apple report to have all the other macros disabled once its been renamed to week start date for now it is 16 Mon 2007.

View 3 Replies View Related

Excel 2010 :: VBA To Start Macro When Changing Data In A Cell

Jul 21, 2014

When a change is made in cell L11, cell N11 should be locked automatically for typing. This is true for the cells between L11:L25, and cells N11:N25.

I have been trying to come up with a code that will:

1 - start my macro when f.ex. L11 is > 0
2 - lock N11 when L11 is filled out
3 - unlock N11 when the input in L11 is deleted

This is my attempt so far to put together a code:

[Code] .....

I'm using Excel 2010.

View 1 Replies View Related

File Browsing In Macro - How To Change Default Start Location?

Sep 28, 2008

I use an image analysis program ImagePro which can call Excel within it's macro language (which seems to be visual basic). I looked up on this site how the change the drive (ChDrive command). But still when the Excel section (after With oExcel) executes the default file location in the browser is in My Documents on the C: drive.

Prior to this code Excel has been launched by this ImagePro macro, and a file Cumberland Template has been opened from the C: drive. Now I would like to do a Save As, but have Excel start at the I: drive location.

View 7 Replies View Related

Run Macro Time: Start A Sub Running At A Selected Time

May 23, 2007

how to include a line of code, to start a sub running at a selected time? Given that the workbook is already opened before that time?

View 6 Replies View Related

Automate Macro Start On Time & Stop At Later Time

Dec 25, 2007

Can I adapt this code so that users receive the alert if they try and go to the next field without filling in the required ones, or - better - to combine it with a code that does not run a macro, but instead gives the alert, if the required fields have been missed. (I don't require anything to do with printing, this was the closest code I could find)

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Sheet1. Range("A1").Value = "" Then
MsgBox "Cannot print until required cells have been completed!"
Cancel = True
End If
End Sub

View 4 Replies View Related

Using ' In Cells: Add A ' To The Start

Dec 15, 2008

I currently have a number of spreadsheets with number data in it. I need to import it into a third party program. Unfortunately when this program imports it it counts numbers such as 1 as 1.0. This third party program says the only way around this is to put a ' before the numbers and this seems to fix the problem. My problem is that I have so much data I cannot go through ever cell and add a ' to the start. IS there a quick way to add ' to the start of certain cells?

View 4 Replies View Related

Start With In An If Then Statement

Jan 14, 2009

Is there a way to use a wild card character in an excel formula? i.e have a formula =IF(AND(B2<>"",A2<>"Fax",A2>"Conference"),1,2) What I am looking to do is put a 1 if a cell starts with Fax or conference.

View 2 Replies View Related

Only Visible On Start Up

May 9, 2009

I have a workbook that is set to show a form on startup and then the code tells excel to be visible = false. How ever i have disabled the close button on my form therefore i have stuffed my program up and cant edit it at all.

View 3 Replies View Related

Always Start In Certain Cell/row

Jan 18, 2010

I have a macros that copy’s certain bits of data forma row, then copies it to another sheet, however I always need it to start in column A. E.g. if my active cell is C3, I want to start in A3, likewise if the active cell is E3, I want to be able to start in A3.

View 13 Replies View Related

How To Limit A Value To 360 And Start From Zero

Jan 27, 2012

I have a formula that adds two numbers. Here it is:


I don't want the numbers to be more than 360 when added up. When it reaches 360, I want it to start over from zero. Instead of, say, E10 = 200 and C8 = 200 ... I don't want the answer to be 400, I want it to be 40.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved