You're welcome Harry... What error were you getting ?
Regarding the type of controls, below link throws some light - http://www.ozgrid.com/Excel/Excel-controls-forms-toolbox.htm Cheers! AJ On Tue, Apr 13, 2010 at 7:50 AM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > 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
