Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I am having 3 VBA Codings, 2 VBA codings are written in Module and the last vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are VBA Coding Names FIRS_T SECON_D THIR_D Now I want to write another coding in VBA to run that three vba codes. If I run this new coding then it should run the above three VBA codes. I dont know how to do it. Pls Suggest. -------------------- (MS-Exl-Learner) -------------------- |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sub RunAll
FIRS_T SECON_D THIR_D end Sub Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "MS-Exl-Learner" wrote in message ... Hi, I am having 3 VBA Codings, 2 VBA codings are written in Module and the last vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are VBA Coding Names FIRS_T SECON_D THIR_D Now I want to write another coding in VBA to run that three vba codes. If I run this new coding then it should run the above three VBA codes. I don't know how to do it. Pls Suggest. -------------------- (MS-Exl-Learner) -------------------- |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am getting the below mentioned error message
Compile Error: Sub or Function not defined Please guide me. -------------------- (MS-Exl-Learner) -------------------- "Robert Flanagan" wrote: Sub RunAll FIRS_T SECON_D THIR_D end Sub Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "MS-Exl-Learner" wrote in message ... Hi, I am having 3 VBA Codings, 2 VBA codings are written in Module and the last vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are VBA Coding Names FIRS_T SECON_D THIR_D Now I want to write another coding in VBA to run that three vba codes. If I run this new coding then it should run the above three VBA codes. I don't know how to do it. Pls Suggest. -------------------- (MS-Exl-Learner) -------------------- |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try the below
Sub RunAll() FIRS_T Secon_d ThisWorkbook.Thir_d End Sub If this post helps click Yes --------------- Jacob Skaria "MS-Exl-Learner" wrote: I am getting the below mentioned error message Compile Error: Sub or Function not defined Please guide me. -------------------- (MS-Exl-Learner) -------------------- "Robert Flanagan" wrote: Sub RunAll FIRS_T SECON_D THIR_D end Sub Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "MS-Exl-Learner" wrote in message ... Hi, I am having 3 VBA Codings, 2 VBA codings are written in Module and the last vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are VBA Coding Names FIRS_T SECON_D THIR_D Now I want to write another coding in VBA to run that three vba codes. If I run this new coding then it should run the above three VBA codes. I don't know how to do it. Pls Suggest. -------------------- (MS-Exl-Learner) -------------------- |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you it's working fine.
But now the VBA codes are Starting with Sub function only. If it is in Sub Function then its working fine. But if i change the 3 VBA Macros as Private Sub then it's showing the below error message. Compile Error: Method or data member not found Thank you, -------------------- (MS-Exl-Learner) -------------------- "Jacob Skaria" wrote: Try the below Sub RunAll() FIRS_T Secon_d ThisWorkbook.Thir_d End Sub If this post helps click Yes --------------- Jacob Skaria "MS-Exl-Learner" wrote: I am getting the below mentioned error message Compile Error: Sub or Function not defined Please guide me. -------------------- (MS-Exl-Learner) -------------------- "Robert Flanagan" wrote: Sub RunAll FIRS_T SECON_D THIR_D end Sub Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "MS-Exl-Learner" wrote in message ... Hi, I am having 3 VBA Codings, 2 VBA codings are written in Module and the last vba coding is written in THIS WORKBOOK. The 3 VBA Coding Names are VBA Coding Names FIRS_T SECON_D THIR_D Now I want to write another coding in VBA to run that three vba codes. If I run this new coding then it should run the above three VBA codes. I don't know how to do it. Pls Suggest. -------------------- (MS-Exl-Learner) -------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changes Required In Macro Code | Excel Discussion (Misc queries) | |||
Another VB Code Required | Excel Discussion (Misc queries) | |||
VB Code Required | Excel Discussion (Misc queries) | |||
macro code required | Excel Worksheet Functions | |||
help required in completing the code | Excel Discussion (Misc queries) |