Hello Mohammed, Agree on the subject line bit.. please use a short decsriptive subject line - and best not to change the subject line if you post again, it can be more difficult for others to follow the thread.
To your question: the main part "How to merge the multiple macros in single
program?" - I understand that question. but I don't understand what your
sample data that looks like payroll records has to do with it. Or what
filtering the payroll data in various ways has to do with it.
CALL is a VBA/macro command, as xlstime says that can execute other
VBA/macro procedures. But, CALL is optional an usually not used. It is as
simple as typing the name of another sub procedure as in this example, which
doesn't use call:
Sub Macro1234 ()
'Execute Macro1 if user hits "Yes" button.
If MsgBox("Execute Macro1?",vbYesNo)=vbYes Then Macro1
'Execute Macro2 if userr hits "Yes" button.
If MsgBox("Execute Macro2?",vbYesNo)=vbYes Then Macro2
'Execute Macro3 if user hits "Yes" button.
If MsgBox("Execute Macro3?",vbYesNo)=vbYes Then Macro3
'Execute Macro4 no matter what!!!
Macro4
End Sub
Sub Macro1 ()
MsgBox "MACRO 1 !"
End Sub
Sub Macro2 ()
MsgBox "MACRO 2!"
End Sub
Sub Macro3 ()
MsgBox "MACRO 3 !"
End Sub
Sub Macro4 ()
MsgBox "MACRO 4 !"
End Sub
Hope this helps.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of xlstime
Sent: Monday, February 20, 2012 12:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express
properly in my previous mail - so let us have it right now)....
if i am not wrong u can use CALL macro function........
On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer <mmun...@ccc.com.qa>
wrote:
How to merge the Multiple Macro's in single program?
My question is little jovial - but still it is trying to learn some thing
from u masters. Thanx anyway....
This is only an example, that I put it here to show u exactly what I want u
to help me for. ( in fact, I need the logic - How I can merge the multiple
macros to form a single programming code).
Or else u can do a help by providing me with any website like this that can
fetch me the right/full explanation about the steps involved in doing so?
If my data is like this: (with Filter buttons are on): (filtering process
taken up in anyway with the help of the "Cell" reference (or) "Button". Its
u r choice)...
Ename
Start Date
End Date
Hours wor
Tot pay
Ded
Net pay
AA
1-Jan-12
31-Jan-12
40.0
2,600.0
650.0
1,950.0
BB
1-Jan-12
31-Jan-12
45.0
1,800.0
450.0
1,350.0
CC
1-Jan-12
31-Jan-12
32.0
1,472.0
368.0
1,104.0
DD
1-Jan-12
31-Jan-12
60.0
2,100.0
525.0
1,575.0
EE
1-Jan-12
31-Jan-12
52.0
1,664.0
416.0
1,248.0
FF
1-Jan-12
31-Jan-12
80.0
2,000.0
500.0
1,500.0
309.0
11,636.0
2,909.0
8,727.0
Regards,
Muneer,
CC...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
.........................
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
<<image001.gif>>
