excel vba examples of changing active workbook

Sample Codes for Worksheet_SelectionChange Event:īackground color of a cell(s) changes to blue each time a new selection is made, only if a single and empty new cell is selected: See the Worksheet Change Event in VBA and Preventing Event Loops page for details on using the Target parameter, Error Handlers and to Enable or Disable Events in a code. In this manner, you can limit the events to a particular range for both the Change and SelectionChange events. If Target is not in the defined Range, nothing will happen in the worksheet. If Target is in the defined Range, and when the selection changes within this Range, it will trigger the vba procedure. It refers to the SelectionChange Range and can consist of one or multiple cells. Target is a parameter of data type Range (ie. Private Sub Worksheet_SelectionChange(ByVal Target As Range) You will get a procedure 'shell' in the code window as follows: To create a worksheet SelectionChange event: use the Visual Basic Editor -> in the Project Explorer, double click on the appropriate sheet (under 'Microsoft Excel Objects' which is under the VBAProject/name of your workbook) -> in the Code window, select 'Worksheet' from the left-side 'General' drop-down menu and then select 'SelectionChange' from the right-side 'Declarations' drop-down menu. it must be placed in the code module of the appropriate Sheet object. Worksheet SelectionChange procedure is installed with the worksheet, ie. The Worksheet_Change event fires when content in a cell changes, while the Worksheet_SelectionChange event fires whenever a new cell is selected.

The selection change event occurs when the selection changes on a worksheet, either by the user or by any VBA application. You can auto run a VBA code, each time that you make a new selection on the worksheet, with the Worksheet_SelectionChange event. Preventing Event Loops with Application.EnableEvents = False Worksheet Change Event in VBA and Preventing Event Loops. Sub HideWorksheet()Ĭhange the sheet name from the above code to use it further.Worksheet Selection Change Event in Excel VBA and Preventing Event LoopsĮxcel VBA Events, Event Handler, Trigger a VBA Macro. May be you want to navigate to a worksheet and hide all the other worksheets from the workbook. If you want to activate a specific worksheet every time when you open the workbook then you name that VBA code auto_open. In the real life, you can use this method in different ways. So the final code will be: Sub ActivateSheet1()Įnd Sub Examples: Activate a Worksheet with VBA Let’s say if you need to activate sheet1, then the code will be: Worksheets('Sheet1').Activate In this method, you can specify worksheet’s name or number which you want to activate. Before you write this code, you need to understand this method.

In this post, I’d like to share with you a simple way to write this code to activate or select a worksheet. And, to write a VBA code for this you need to use Worksheet.Activate Method.

Excel vba examples of changing active workbook