I have a userform that works great on PC, but it wasn't working on Mac, so I got a Mac tweak, and when I tested it on a Mac, it worked. I just found out it doesn't work on some Macs--I just tested on a different one today.
Users enter items in a list to create their drop-down menu: they enter each item on a separate line in the userform box. On a Mac, it wasn't putting them in a separate cell. It grouped every item in their list into one cell, so there was only one choice for their drop-down menu--a combination of all their items.
This code below works on some Macs (some macs will put the items in the list on separate lines, but didn't on the one I tested on today.)
The Mac I am testing on right now is OS X El Capitan Version 10.11.6 operating system and the Excel is 2011.
Any ideas?
Bookmarks