HOW TO SELECT MULTIPLE OBJECTS IN WORD CODE

Instead of using column 2, you could change to a different number,В or useВ multiple columns, such as: Case 2, 5, 6 Let the magic work for you

HOW TO SELECT MULTIPLE OBJECTS IN WORD CODE

Then, if it was column 2 (B), the rest of the code will run. In the screen shot below, the code checks to see which column that Target cell was in. In the code, Target refers to the cell that you changed.

There is one line of code that you can change, if your dropdown list is not in column B. That code runs automatically if Dee makes a change on the sheet.Д®ven if you donвЂ™t know anything about programming, you could copy this code and use it in your workbook. At the right, we can see the Worksheet_Change event code for that worksheet. In the project list at the left, the FridayStaffName workbook is listed, and the Friday_Staff sheet is highlighted. That will open the Visual Basic Explorer (VBE). To see the code for a worksheet, right-click on its sheet tab and click View Code.

LetвЂ™s take a peek at the code and see how you can use this trick in your worksheets. The code keeps the old name in the cell, and adds a comma, followed by the new name. To let Dee select multiple names in each cell, weвЂ™ll add a bit of magic to her worksheet with a few lines of VBA code. The dropdown list works well for selecting one name, but if Dee selects a second name in a cell, it overwrites the first name. To keep track of who will stay in the office each week, Dee, the office manager, created an Excel file.В This file contains a list ofВ the employee names and a list of weeks.В Dee created a dropdown list of employee names for each week.

How to select multiple objects in word