Re: $$Excel-Macros$$ Fwd: Short Keys

2010-03-13 Thread SHAH DARSHIL
It's really great. nice documents Thanks.. Every one should learn for share good things & help each other. Regards, Darshil Shah. On Sat, Mar 13, 2010 at 12:13 AM, big smile wrote: > > > -- > > > > -- Subject: Short Keys > > > > > > > > > > -- > > Mother Teresa:- If we cannot l

Re: $$Excel-Macros$$ VBA to detect a corrupt excel workbook

2010-03-13 Thread mike
Anyone?? -- -- 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=28777955567

Re: $$Excel-Macros$$ Why I cannot call the textbox control value this way?

2010-03-13 Thread rf1234 rf1234
Dear Nasuko Your solution is available here now,i hope it will work now. i have rearrange your code now. '

$$Excel-Macros$$ Re: Uncertain number of input for VBA function

2010-03-13 Thread Sukiyaki
Since no one is asswering my question, may be people do not understand it. Let me give more example. Usually, we use a fixed number of parameters/inputs or a range for a UDF. Example: Function xyz(a as double, b as double) as double xyz = a + b End Function Or Function xyz(rng a

$$Excel-Macros$$ Why I cannot call the textbox control value this way?

2010-03-13 Thread Sukiyaki
Hello, I want to call value from a textbox control (textbox1) which is placed on Sheet1 to a cell in Sheet2. I use the following code to do it: Dim sht1 As Worksheet Dim sht2 As Worksheet Set sht1 = ThisWorkbook.Worksheets("Sheet1") Set sht2 = ThisWorkbook.Worksheets("Sheet2")

$$Excel-Macros$$ Help

2010-03-13 Thread sudhir kumar
Hi all Can any send me Guide of VB's in PDF format. -- Sudhir Verma Asstt. Mngr. A/c's 9211219649 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/

Re: $$Excel-Macros$$ Fwd: Short Keys

2010-03-13 Thread asha abraham
That is great! U really made to smile... On Sat, Mar 13, 2010 at 10:43 AM, big smile wrote: > > > -- > > > > -- Subject: Short Keys > > > > > > > > > > -- > > Mother Teresa:- If we cannot love the person whom we see, how can we love > god, whom we cannot see ? > > -- > >