In this article, we will learn the MsgBox function in Excel VBA, Following are the buttons argument settings of msgbox vba: Constant Value Description vbOKOnly 0 Display OK button only. vbOKCancel 1 Display OK and Cancel buttons. vbAbortRetryIgnore 2 Display … Continue reading
In Microsoft Excel,we can sort the data by using the AutoFilter sort’s data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A … Continue reading
In this article, we will learn how we can allow multiple users to edit the ranges in Microsoft Excel. From the Tools menu, select Protection, and then Allow Users to Edit Ranges. This advanced option allows multiple users (for example, … Continue reading
In this article we will learn how to find the duplicate items in combined columns. To find duplicate items we use the “COUNTIF” and “IF” formulae in Microsoft Excel. IF:-IF condition allows us to specify multiple conditions in a cell. It … Continue reading
File Menu: * Excel 2002: Search, and a new Search icon on the regular Standard toolbar. * Excel 2003: File Search. The File Search icon does not appear on the Standard toolbar, but can be added from the Tools category … Continue reading
To let Excel read text for you: 1. Select a range of cells. 2. From the Tools menu, select Speech and then Show Text To Speech Toolbar. 3. Click the leftmost icon, Speak Cells, or click Speak On Enter (the … Continue reading
In this article, we have created a macro to highlight duplicate values. Raw data consists of different car names. We want to highlight duplicate entries. Press the “Highlight duplicate” button to run the macro and highlight duplicate entries. Logic explanation … Continue reading
Selecting special cells in a sheet, for example, cells containing Constants, Formulas, blank cells, and more, enables you to copy, move, delete, color, fill, or protect these cells. We use ‘Go to special’ tool to select the constants, formulas, blank … Continue reading
New menu items, cell shortcut menu items and keyboard shortcuts: * In the File menu: File Search and Permission * In the View menu: Keyboard shortcut Ctrl+F1 makes the Task Pane visible. To hide it, press Ctrl+F1(its toggle). * In … Continue reading
In this article, we are going to learn how to calculate the sum across the multiple sheets in Microsoft Excel. Let’s take an example and understand:- We have yearly history of football’s games in Excel file for every country and … Continue reading
