Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a macro within an excel formula
Is it possible to call a macro from within and excel 2003 If statement as
follows: =If(IF(M2 <=LASTSN,copymacro[then i want to call a print macro and move down a row and repeat this formula for M3, until M# is no longer <= LASTSN) I have been unsuccessfully trying to find and modify macros that others used to create sequential serial numbers for a week now, and have not yet got them to work; probably because I have never worked with Visual Basic before and do not really understand its syntax. -- rahne059 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a macro within an excel formula
Addon - here is the partial macro i wrote so far:
Sub copypaste() ' ' copypaste Macro ' Macro recorded 1/15/2010 by rstembler ' ' Keyboard Shortcut: Ctrl+a ' Range("M2").Select Selection.Copy ActiveWindow.LargeScroll ToRight:=-1 Range("D5").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets(Array("Layup Worksheet Pg1 ", "Layup Worksheet Pg2", "Layup Worksheet Pg3" _ )).Select Sheets("Layup Worksheet Pg1 ").Activate Application.CutCopyMode = False ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True ActiveWindow.LargeScroll ToRight:=1 AT THIS POINT IT NEEDS TO ROLL BACK TO THE IF STATEMENT AND THEN CONTINUE TO CHANGE RANGES AND LOOP UNTIL M# LASTSN Range("M3").Select Selection.Copy ActiveWindow.LargeScroll ToRight:=-1 Range("D5").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub I USED TO BE ABLE TO DO THIS ON A WANG ALL-IN-ONE MAINFRAME COMPUTER, BUT OBVIOUSLY VISUAL BASIC USES DIFFERENT RULES. -- rahne059 "rahne059" wrote: Is it possible to call a macro from within and excel 2003 If statement as follows: =If(IF(M2 <=LASTSN,copymacro[then i want to call a print macro and move down a row and repeat this formula for M3, until M# is no longer <= LASTSN) I have been unsuccessfully trying to find and modify macros that others used to create sequential serial numbers for a week now, and have not yet got them to work; probably because I have never worked with Visual Basic before and do not really understand its syntax. -- rahne059 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a macro within an excel formula
Nope.
You can use a user defined function in that formula, but (almost) all that it can do is return a value to the cell that contains that function/formula. Maybe you can add a button from the Forms toolbar and assign your macro to that. Then tell the user to hit the button to run the macro when they need it. rahne059 wrote: Is it possible to call a macro from within and excel 2003 If statement as follows: =If(IF(M2 <=LASTSN,copymacro[then i want to call a print macro and move down a row and repeat this formula for M3, until M# is no longer <= LASTSN) I have been unsuccessfully trying to find and modify macros that others used to create sequential serial numbers for a week now, and have not yet got them to work; probably because I have never worked with Visual Basic before and do not really understand its syntax. -- rahne059 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling a macro in excel | Excel Programming | |||
calling macro in a formula | Excel Discussion (Misc queries) | |||
calling excel macro | Excel Programming | |||
Calling Excel Macro From Vc++ via DDE | Excel Programming | |||
calling a dll from excel macro | Excel Programming |