JA EXCEL

Form controls in Excel are objects that you can add to a worksheet to create interactive forms, questionnaires, or surveys. These controls can be used to input or display data, and to trigger actions based on user input. Some of the most commonly used form controls in Excel include: Check boxes: These are used to give users a simple yes/no or true/false option. Radio buttons: These are used to provide users with a set of mutually exclusive options from which they must choose one. Drop-down lists: These are used to provide users with a list of options from which they can select one. Combo boxes: These are similar to drop-down lists, but they also allow users to type in a custom option. Spin buttons: These are used to increment or decrement a value in a cell by a certain amount. Scroll bars: These are used to provide a visual way for users to adjust a value within a range. Text boxes: These are used to allow users to input text or numerical data. Option buttons: These are simil...

\ Form controls in Excel are objects that you can add to a worksheet to create interactive forms, questionnaires, or surveys. These controls can be used to input or display data, and to trigger actions based on user input. Some of the most commonly used form controls in Excel include: Check boxes: These are used to give users a simple yes/no or true/false option. Radio buttons: These are used to provide users with a set of mutually exclusive options from which they must choose one. Drop-down lists: These are used to provide users with a list of options from which they can select one. Combo boxes: These are similar to drop-down lists, but they also allow users to type in a custom option. Spin buttons: These are used to increment or decrement a value in a cell by a certain amount. Scroll bars: These are used to provide a visual way for users to adjust a value within a range. Text boxes: These are used to allow users to input text or numerical data. Option buttons: These are simi...

Mail merge is a feature in word processing programs, such as Microsoft Word, that allows you to create personalized documents, such as letters or emails, by combining a standard document with a data source. This is particularly useful when you need to create multiple documents that share the same format but contain unique information for each recipient. To perform a mail merge, you typically start by creating a standard document that contains the text and formatting you want to use for all the documents. Next, you create a data source, which can be a spreadsheet or database, that contains the unique information for each document, such as names and addresses. Once you have your standard document and data source, you can use the mail merge feature to combine the two. The software will automatically insert the unique information from the data source into the appropriate places in the document, creating a personalized document for each recipient. Mail merge is commonly used for crea...

Click here to download addin or copy paste below code in your excel module Function Numbertowords(ByVal MyNumber)     Dim Rupees, paisa, Temp     Dim DecimalPlace, Count     ReDim Place(9) As String     Place(2) = " Thousand "     Place(3) = " Million "     Place(4) = " Billion "     Place(5) = " Trillion "     ' String representation of amount.     MyNumber = Trim(Str(MyNumber))     ' Position of decimal place 0 if none.     DecimalPlace = InStr(MyNumber, ".")     ' Convert paisa and set MyNumber to Rupee amount.     If DecimalPlace > 0 Then         paisa = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _                   "00", 2))         MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))     End If     Count = 1     Do While MyNumbe...