Well all you have to do is to follow following steps;
Step-1: open a new file, open the VBA Module by pressing Atl-F11 and past the code for converting Number into Text (Words), simply save this file as Add-Ins, when you will try to save the file, you have to select the file type and in file types u will see two options, one is for Excel 97-2003 as Add-Ins 97-2003 and other option for Excel 2007, with only name as Add-Ins, all you have to do is to select that simple Add-In option and save the file with the name u like to (I saved it as “SpellNumber” easy for me to remember). After saving it close the VBA Module by pressing Alt-
Step-2: Go and open new excel workbook, select the Office>Select Option>Select Add Ins, you will see in the list of Add Ins, there is an Add In (SpellNumber, with Owner Name as yours), select that Add In & Press Go under the bottom where mentioned (Manage [Com Add Ins]-Go), select this Go.
Step-3: A new popup block will open which shows the already available Add-Ins including the new SpellNumber with an unchecked box, check the box and close this popup block.
Step-4: Now write a figure anywhere in any cell and select the Formulas, in Formula Library select the Insert Function command and a list of functions will appear, select from the category list the User Define Functions and you will find your function “SpellNumber”, select the function and got the result.
Enjoy the Solution.
For more details see below :
User-Defined Functions in ExcelExcel allows you to create custom functions, called "User Defined Functions" (UDF's) that can be used the same way you would use SUM(), VLOOKUP, or other built-in Excel functions. The Excel user who wishes to use advanced mathematics or perform text manipulation is often seriously disappointed by Excel's limited library of formulas and functions. A UDF is simply a function that you create yourself with VBA. This blog will help you get started with UDFs and show a couple of examples.
Sample UDFThe following is a sample that is a good candidate for a UDF:
Function CtoF(Centigrade) CtoF = Centigrade * 9 / 5 + 32End Function
Step-1: open a new file, open the VBA Module by pressing Atl-F11 and past the code for converting Number into Text (Words), simply save this file as Add-Ins, when you will try to save the file, you have to select the file type and in file types u will see two options, one is for Excel 97-2003 as Add-Ins 97-2003 and other option for Excel 2007, with only name as Add-Ins, all you have to do is to select that simple Add-In option and save the file with the name u like to (I saved it as “SpellNumber” easy for me to remember). After saving it close the VBA Module by pressing Alt-
Step-2: Go and open new excel workbook, select the Office>Select Option>Select Add Ins, you will see in the list of Add Ins, there is an Add In (SpellNumber, with Owner Name as yours), select that Add In & Press Go under the bottom where mentioned (Manage [Com Add Ins]-Go), select this Go.
Step-3: A new popup block will open which shows the already available Add-Ins including the new SpellNumber with an unchecked box, check the box and close this popup block.
Step-4: Now write a figure anywhere in any cell and select the Formulas, in Formula Library select the Insert Function command and a list of functions will appear, select from the category list the User Define Functions and you will find your function “SpellNumber”, select the function and got the result.
Enjoy the Solution.
For more details see below :
User-Defined Functions in ExcelExcel allows you to create custom functions, called "User Defined Functions" (UDF's) that can be used the same way you would use SUM(), VLOOKUP, or other built-in Excel functions. The Excel user who wishes to use advanced mathematics or perform text manipulation is often seriously disappointed by Excel's limited library of formulas and functions. A UDF is simply a function that you create yourself with VBA. This blog will help you get started with UDFs and show a couple of examples.
Sample UDFThe following is a sample that is a good candidate for a UDF:
Function CtoF(Centigrade) CtoF = Centigrade * 9 / 5 + 32End Function
thanks bro for the help
ReplyDeletethanks
ReplyDeleteThank u so much
ReplyDeleteIts not coming as Com Add in as we are saving as Excel Ad in
ReplyDeleteIt's working no doubt, thankyou !
ReplyDelete