![]() Private Sub Worksheet_SelectionChange(ByVal Target As Range) A new Code window opens.Ĭlick the first drop-down box in the Code window and select "Worksheet."Ĭlick the Code window's second drop-down box and choose "SelectionChange." The Code window now displays the following: For example, if this cell is located in the "Staff" sheet, which is the first sheet in the workbook, click "Sheet1 (Staff)" in the Project box outline. This box displays an outline of your project and lists each sheet in the workbook.ĭouble-click the sheet that contains the cell to which you want to attach an event. Identify the Project box in the upper left corner of your workspace. The Visual Basic for Applications window opens. ![]() Click "Visual Basic" from the ribbon's Code tab.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |