Re: $$Excel-Macros$$ Re: Share your Coolest VBA codes!

2009-11-24 Thread Aindril De
Hi Mahesh, Please insert a Module and add the above code... The usage is as follows: Assuming the value is in Cell A1 and we want the Text in Cell B1 Then in B1 type : =CurrencyToWord(A1) Regards, Andy On Tue, Nov 24, 2009 at 4:48 PM, Mahesh wrote: > Hi Aindri, > > Please also share how t

Re: $$Excel-Macros$$ Re: Share your Coolest VBA codes!

2009-11-24 Thread Mahesh
Hi Aindri, Please also share how to use this code. i mean to say how to start it after writing it. On Mon, Nov 23, 2009 at 9:12 AM, Aindril De wrote: > Great Idea Hemant!! > > Here goes my code!! > The following code is to Convert Currency to Words(Indian Style) > > > > 'Please make a Module a

Re: $$Excel-Macros$$ Re: Share your Coolest VBA codes!

2009-11-22 Thread Aindril De
Great Idea Hemant!! Here goes my code!! The following code is to Convert Currency to Words(Indian Style) 'Please make a Module and add the code... Option Explicit ' Function for conversion of a Currency to words ' Parameter - accept a Currency ' Returns the number in words format '**