Aj, Thanks for the solutions, i will try to test it extensively, as i am not sure, why i was getting that error, though i was using pretty much similar command.
Would you be able to highlight, some differences between the command button created from the Visual Basic Toolbar and from a Forms toolbar Cheers Harry On Mon, Apr 12, 2010 at 12:15 PM, Abhishek Jain <abhishek....@gmail.com>wrote: > Harry, > > Have you tried either; > > Application.Run "Test" > > Or > > Application.Run "Book1!Test" > > Both work for me... > > PS: Hope you created you commandbutton from Visual Basic Toolbar and not > from Forms Toolbar. Yes! both are different. :-) > > > Cheers! > > AJ > > > On Mon, Apr 12, 2010 at 8:16 AM, Harpreet Singh Gujral < > harpreetguj...@gmail.com> wrote: > >> Thanks everybody for your responses. >> >> The trouble is the most, when the subroutine is defined as Private >> Sub. Any solutions to this: >> >> Example2: >> >> >> Module1 has "test1" stored as a Private sub >> >> >> and i want to call this Sub in a Commandbutton created on Sheet1 >> >> >> Thanks >> >> Harry >> >> On Apr 11, 6:43 pm, rf1234 rf1234 <rfhyd1...@gmail.com> wrote: >> > Hello dear >> > You can call function in any of event... >> > i.e >> > workbook open >> > button click >> > sheet active >> > .. >> > ... >> > Most important is Calling the function. >> > >> > Private Sub CommandButton1_Click() >> > call test1 >> > End Sub >> > >> > Hope it will Help >> > Happy to Help >> > :) >> > Prashant Tripathi >> > >> > >> > >> > >> > >> > On Sun, Apr 11, 2010 at 6:59 PM, Daniel <dcolarde...@free.fr> wrote: >> > > Hello. >> > >> > > Private Sub CommandButton1_Click() >> > >> > > test1 >> > >> > > End Sub >> > >> > > Regards. >> > >> > > Daniel >> > >> > > De : excel-macros@googlegroups.com [mailto: >> excel-mac...@googlegroups.com] De >> > > la part de harpreetgujral >> > > Envoyé : dimanche 11 avril 2010 15:08 >> > > À : excel-macros@googlegroups.com >> > > Objet : $$Excel-Macros$$ Calling a Macro >> > >> > > Hi Group, >> > >> > > I want to know, how can we call a macro stored in Module1 in other >> modules >> > >> > > Example: >> > >> > > Module1 has "test1" stored as a public sub >> > >> > > and i want to call this Sub in a Commandbutton created on Sheet1 >> > >> > > Example2: >> > >> > > Module1 has "test1" stored as a Private sub >> > >> > > and i want to call this Sub in a Commandbutton created on Sheet1 >> > >> > > If anybody knows about a weblink which briefs about all the ways of >> calling >> > > a macro, then please let me know >> > >> > > Cheers! >> > >> > > Harry >> > >> > > -- >> > > >> ---------------------------------------------------------------------------------- >> > > Some important links for excel users: >> > > 1. Follow us on TWITTER for tips tricks and links : >> > >http://twitter.com/exceldailytip >> > > 2. Join our Facebook Group @ >> > >http://www.facebook.com/group.php?gid=287779555678 >> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> > >> > > To post to this group, send email to excel-macros@googlegroups.com >> > >> > > <><><><><><><><><><><><><><><><><><><><><><> >> > > HELP US GROW !! >> > >> > > We reach over 6,800 subscribers worldwide and receive many nice notes >> about >> > > the learning and support from the group.Let friends and co-workers >> know they >> > > can subscribe to group at >> > >http://groups.google.com/group/excel-macros/subscribe >> > >> > > -- >> > > >> ---------------------------------------------------------------------------------- >> > > Some important links for excel users: >> > > 1. Follow us on TWITTER for tips tricks and links : >> > >http://twitter.com/exceldailytip >> > > 2. Join our Facebook Group @ >> > >http://www.facebook.com/group.php?gid=287779555678 >> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> > >> > > To post to this group, send email to excel-macros@googlegroups.com >> > >> > > <><><><><><><><><><><><><><><><><><><><><><> >> > > HELP US GROW !! >> > >> > > We reach over 6,800 subscribers worldwide and receive many nice notes >> about >> > > the learning and support from the group.Let friends and co-workers >> know they >> > > can subscribe to group at >> > >http://groups.google.com/group/excel-macros/subscribe >> > >> > -- >> > >> > Thanks Regards >> > Shyam >> > Software Engineer >> > >> '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' >> > When one door of happiness closes, another opens; >> > but often we look so long at the closed door that we do not see the >> > one which has been opened for us. >> > - Helen Keller >> > >> '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' >> > Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, >> > aber oft schauen wir so lange auf die geschlossene Tür, >> > dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller >> > >> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''- >> Hide quoted text - >> > >> > - Show quoted text - >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> To unsubscribe, reply using "remove me" as the subject. >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
