With this little bit of magic added to her worksheet, Dee can quickly and easily select the office staff for the Friday afternoon shifts. 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
#Creating a dropdown in excel for mac 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.
0 kommentar(er)
