There are 3 separate list box controls. Worksheet (works on Mac and PC) Userform (works on Mac and PC) Active-X (PC only) If you want the control to live right on the worksheet use the Worksheet control. If you set the selection type to Multi or Extend, the cell that is specified in the Cell link box returns a value of 0 and is ignored.

How to Create a Drop-Down List in Excel 2016. Go back to Sheet 1 and select the first cell you want the drop-down list to be in. Go to the Data tab and click Data Validation. Open the drop-down Allow:, and choose List. In the Source area, type in the equals (=) sign followed by whatever you named your drop-down. Finally, hit OK.

The Multi and Extend selection types require the use of Microsoft Visual Basic for Applications (VBA) code. When searching for help on how to use VBA make sure the help topic is about either the Worksheet or Userform control (whichever you have chosen), and not the Active-X control.

I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.

A dock will be any adapter that fits flush with the machine or is meant to remain on a desk. You will also notice companies will call their devices “hubs.” Just go down the list and pick one that covers all your plug-ins. You can do this. Don’t let the format add to your USB-C anxiety. Best usb hub for apple macbook.