![Resize Resize](/uploads/1/1/8/9/118984363/857976025.jpg)
Mar 14, 2012 I cannot find the field to specify RowSource in the UserForm properties for combo box or listbox in Excel for Mac 2011. Is this hidden for some reason? If it's not there in the properties box, how do I specify the Input Range/RowSource for such boxes inside a UserForm? You can try the code below on a Mac in Excel 2011 to always open the userform in the center of your Excel window. Note: The code below will not work in 2016 and higher because the Macscript function is not working anymore in a lot of situations because of Apple Sandbox requirements.
- Points
- 355
- Trophies
- 1
- Posts
- 39
I cannot find the field to specify RowSource in the UserForm properties for combo box or listbox in Excel for Mac 2011. Is this hidden for some reason? If it's not there in the properties box, how do I specify the Input Range/RowSource for such boxes inside a UserForm?- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.
How Do I Resize A Userform In Excel 2011 For Mac Pdf
Hi all.
I developed a nice excel program for configuring one of our products and it works quite well.
Initially this will be used as a Sales tool and I have recently released it to the Sales team.
However, as this was developed on Windows OS, any of the Sales team that uses a Mac are having problems with my user forms. I.e. they can open the user form by clicking on a button but all of the drop down menus are showing as empty.
I checked the code on a mac and noticed that the user form itself cant be edited.
Is this a general let down of excel on Mac or am I missing something?
Thanks in advance for your help.
Barry