IF THEN ELSE statement
Excel » VBA » Statements » IF THEN ELSE statement »
How to use the IF THEN ELSE ELSEIF END IF statement [VBA]
The picture above demonstrates an IF statement that checks if the value in B3 is smaller than the value in […]
Find the longest/smallest consecutive sequence of a value [VBA]
This post Find the longest/smallest consecutive sequence of a value has a few really big array formulas. Today I would like to show […]
Did you know that you can select all comments in the current sheet? Press F5, click "Special..." button, select "Comments" […]
Show / hide a picture using a button
This article explains how to hide a specific image in Excel using a shape as a button. If the user […]
Run a Macro from a Drop Down list [VBA]
This article demonstrates how to execute a VBA macro using a Drop Down list. The Drop Down list contains two […]
This workbook contains two worksheets, one worksheet shows a calendar and the other worksheet is used to store events. The […]