Re: $$Excel-Macros$$ help me

2011-05-16 Thread memonkavi
> Use this formula, > > =roundup(5284/12,1) > > *Rajesh Naharwal > > On 15 May 2011 19:27, memonkavi wrote: > > > > > > > > > > > Dear Sir > > > This is my problem > > > one cartoon 12  boxes > > I have 440 c

Re: $$Excel-Macros$$ help me

2011-05-16 Thread memonkavi
thanks oflot Rajesh Nahawal! kavi On May 15, 9:32 pm, Rajesh Naharwal wrote: > Hi Dear, > > Use this formula, > > =roundup(5284/12,1) > > *Rajesh Naharwal > > On 15 May 2011 19:27, memonkavi wrote: > > > > > > > > > > > Dear Sir >

Re: $$Excel-Macros$$ help me

2011-05-16 Thread memonkavi
thanks alot rajan verma!! kavi On May 15, 9:10 pm, rajan verma wrote: > Use minus Sign before your formula... > > > > > > > > > > On Sun, May 15, 2011 at 7:27 PM, memonkavi wrote: > > > Dear Sir > > > This is my problem > &g

$$Excel-Macros$$ help me

2011-05-15 Thread memonkavi
Dear Sir This is my problem one cartoon 12 boxes I have 440 cartoon 4 boxes cartoon 440x12=5280 boxes4 5284/12=440.33 this is excel result I need result-440.4 pls help me how

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

2010-07-04 Thread memonkavi
ement,  find info on below link. > > >http://www.ozgrid.com/VBA/ExtractNum.htm > > > On Sun, Jul 4, 2010 at 10:25 AM, memonkavi wrote: > > > DEAR SIR > > > > PLS ME > > > > I NEED EXRACT  WHOLE TEXT AND NUMBER  DIFFERENT

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

2010-07-04 Thread memonkavi
hing a file. > > Best Regards, > Ayush Jain > Group Manager > > On Jul 4, 12:59 pm, Mahesh parab wrote: > > > > > Hi > > > find attach sheet as per your requirement,  find info on below link. > > >http://www.ozgrid.com/VBA/ExtractNum.htm > > &

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

2010-07-04 Thread memonkavi
; On Sun, Jul 4, 2010 at 10:25 AM, memonkavi wrote: > > DEAR SIR > > > PLS ME > > > I NEED EXRACT  WHOLE TEXT AND NUMBER  DIFFERENT CELLS > > WITH ONE FUNCTION OR TWO > > >

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

2010-07-04 Thread memonkavi
End If >     Next i >     extractalltext = text1 > End Function > > Regards > Ashish koul > akoul.blogspot.com > > > > On Sun, Jul 4, 2010 at 10:25 AM, memonkavi wrote: > > DEAR SIR > > &g

$$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

2010-07-03 Thread memonkavi
DEAR SIR PLS ME I NEED EXRACT WHOLE TEXT AND NUMBER DIFFERENT CELLS WITH ONE FUNCTION OR TWO REGRADS KAVI NOTE -HOW ATTACH A SAMPLE FILE THIS GROUP -- -- Some important links for excel users: 1. Follow us on T

$$Excel-Macros$$ how can use excel funcations in user form texrboxes?

2010-05-24 Thread memonkavi
hello sir help following issue thanks memon how can use excel funcations in user form texrboxes? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exce

Re: $$Excel-Macros$$ CONVERT

2010-03-17 Thread memonkavi
sir how to install it help pls On Mar 16, 4:19 pm, Hemant K wrote: > Hi, > > Find this add in this will help you to convert no to text > first install this in and use it > to use for example > in Cell A1 you put no. 2000 > in Cell B1 put formula "=spellnumber(A1)" > you will get result Rs. Two T

Re: $$Excel-Macros$$ minimize a userform

2010-02-05 Thread memonkavi
__ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > __

$$Excel-Macros$$ minimize a userform

2010-02-04 Thread memonkavi
dear sir how to minimize a userform in excel vb? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and

$$Excel-Macros$$ sound with command button

2010-01-29 Thread memonkavi
sir how can add sound in a command button in excel vb? pls help me -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tut

Re: $$Excel-Macros$$ looping by timeing

2010-01-27 Thread memonkavi
onds" > Else >     End > End If > > Using this code in for wait time > > > > On Fri, Jan 15, 2010 at 2:53 PM, memonkavi wrote: > > sir > > how can stop  a loop by time in excel vb code > > > -- > > >

Re: $$Excel-Macros$$ how to looping setting a time limit in excel 2007?

2010-01-20 Thread memonkavi
Ankur Pandey! sir lot of thanks. u waste ur time. and gave some ideas with code for my problem. i will try it. and inform u. once again thanks with sorry for my english regards kavi On Jan 20, 4:19 pm, ankur wrote: > hi memonkavi > > this a extract from a website  http://www.cpearson.

Re: $$Excel-Macros$$ how to looping setting a time limit in excel 2007?

2010-01-20 Thread memonkavi
    MsgBox "done" >     Application.StatusBar = False > End Sub > > Paul > > > From: memonkavi > To: MS EXCEL AND VBA MACROS > Sent: Wed, January 20, 2010 12:58:07 AM > Subject: $$Excel-Macros$$ how to looping setting a time limit

$$Excel-Macros$$ Re: how to looping setting a time limit in excel 2007?

2010-01-20 Thread memonkavi
t; > On Jan 20, 10:58 am, memonkavi wrote: > > > > > sir > >  ex > >   code > > do > > calculate > > loop until --- > >  here i want  

$$Excel-Macros$$ looping by timeing

2010-01-15 Thread memonkavi
sir how can stop a loop by time in excel vb code -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and T