When we are dealing with confidential data we need to Protect Workbook in Excel VBA. So that user can enter password if he has and can view the data in the workbook.
IF Function in Excel - formula helps us to check a condition, it returns one value if a specified condition is TRUE, or another value if the condtion is FALSE
CHOOSE Function in Excel - formula returns a value from a list of values based on a given index position. Learn Formulas, Excel and VBA with examples.
A step by step tutorial to write a simple Hello World VBA macro. Follow the below steps to do this to show the "Hello World!" message box to the user.
INDEX Function in Excel - formula returns either the value or the reference to a value from a table or range. Learn Formulas, Excel and VBA with examples.
MATCH Function in Excel - formula searches for a value in an array and returns the relative position of that item. Learn Formulas, Excel and VBA with examples.
Protect UnProtect Worksheet in Excel VBA if you want to restrict the users to not to modify the structure of the worksheet. You can find more examples here.
The Macro Recorder is a very useful tool available in Microsoft Excel, you can Record Macro in Excel if you want to automate any repetitive task. It helps to save the process time and avoid the human errors. In this section you will learn how to record a macro to automate repetitive task.
We select cell range in Excel VBA to do particular task with the selection. For example we may want to change the background color of a range and we may want to change the font to Bold. In this case we do not required to loop each and every cell of the range to change the background color and font.
HLOOKUP Function in Excel - formula searches for value and returns the value in a given row that matches a value in the top most column of a table.
In this topic I am giving an Introduction to SAS, explaining the basics about SAS in brief. This is for beginners who are just getting started learning SAS. You will find the learning path for Beginners and Advanced Users. Introduction to SAS - What is SAS? SAS stands for Statistical Analysis System or Software, a
SQL Commands will help Analyst to create database,creating new tables and views, update or deleting the existing data. SQL commands help to fetch the data from the database and format it to required standards and summarize to perform analysis.
If you want to use Excel Worksheet Functions like VLOOKUP, SUMIF, COUNTIF in VBA , we can write macros by using Application.WorksheetFunction object.
Application Objects to write Optimized VBA programming to fasten your code - Examples on Enable Events, Screen Updating, Progress Bar, Display Alerts ,etc.
Example to show you how to change font to Bold in Excel using VBA. Also find related examples like Font Color and Background Color changing in Excel VBA.
VBA Environment we also refer as VBE. You can goto Developr tab in the ribbon and Click on the Visual Basic button to go to the VBE or simply press 'Alt+F11' to go to the VBE
We can automate task to Change Text Case - Upper Lower in Excel VBA. See the following examples to know how to do this.
Description: It is an interesting feature in excel, we can change background color of Cell, Range in Excel VBA. Specially, while preparing reports or dashboards, we change the backgrounds to make it clean and get the professional look to our projects. Change Background Color of Cell Range in Excel VBA - Solution(s): We can use
Writing and reading excel using VBA examples will help you to understand the concepts to read and write the data from different Cells, Ranges and Worksheets
VLOOKUP Function in Excel searches for value and returns the value in a given column that matches a value in the left most column of a table. Learn more ...