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,
>
> Th
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 toolb
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 Gu
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, rf123
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
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
