Enable VBA Support for creating and editing UserForms (not the Data Form)
In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.
(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)
Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.
I updated the title and description for this one and we’ll continue to monitor for comments and votes.
Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality
Steve K [MS Excel]
Due to the relatively low number of Mac owners needing VBA, it seems logical that, in order to minimize their cost to benefit ratio (like any company, also Apple of course), Microsoft decided not to put more effort for maintaining VBA in the future. And if such a rare user would imperatively need VBA, he can run Windows on his Mac as well. The Microsoft position is commercially defendable, isn't it ?
It amazes me that Microsoft can't make the Mac app with similar features as the Windows app. Adobe seems to do pretty well had having similar features on Windows and Mac. Of course Adobe is more expensive. Still Microsoft did have this feature in the 2011 version and there shouldn't be any reason for them not to be able to have it in the new version. You can claim lack of funding or lack of developers but I find really hard to believe given the fact it was a feature that had been in the earlier version.
I can bring an answer to your second question only:
Above answer also includes historical arguments. But basically, a cross-platform development can indeed not beat a single-platform development, as far as functional and speed performances are concerned. And the cross-platform development efforts are higher too (complexity). That's what I can tell you in a very first approach.
While it is true that there are more Windows users of Office than Mac users, the 2011 version had a great deal more parity than O367 does. Why is it going backwards?
Also, there are ways to do cross-platform development that produce app for different platforms from the same code base. Why doesn't MS do that?
Let me logically explain the present situation. Assume that, by any reason, Office for Windows and Office for MacOS would be two distinct software product developments. And if any Office user would pay for instance 100 $ for it, independently of his platform, then, due to the much lower market share of the Mac users, the development budget for the Mac version would also be lower. This would explain why your wish for "identical capabilities" cannot be satisfied. Obvious economic reasons.
Lee Townsend commented
Microsoft - please be aware that your Mac customers are very tired of how you treat them. Recall Excel 2008 with no VBA. I will not switch to WIndows. There are other Office type apps out there for Mac. The Mac Office and Windows Office should have identical capabilities upon release.
Good thinking, anonyme.
MS Excel: Userform not available for Macbook Air. I'd rather change to windows
SADD FACE commented
Don't want to but will have to NOT purchase next PC from Apple. Business uses Microsoft Office and that's not changing anytime soon, stop competing start adapting. It's frustrating when you can't transition fluidly to a home machine and continue working. And let's be honest here, the User Forms are not the only shortcoming of this cheap knock off of a program. Get your **** together already Apple.
Thank you Dudley, that link was very informative and appreciated.
Sorry for the delay I have been extremely busy anyway check this link out. look for the reply from Schwieb
David James commented
This is why Apple computers have a very small share of the commercial market. Even in architect’s offices where graphics are important Windows based machine are used. Apple limits what programs can be run, provides some software (Numbers, Pages, Contacts, Mail) all of which is pretty basic and they wonder why they don’t penetrate the commercial market. Linux does better.
Office / Excel / VBA is broadly not the only Windows professional application that is not running on MacOS. Then Windows on VM should be for a business Mac user a profitable investment in general (a Mac machine is already quite expensive).
I have Excel 16.27 now and it still does not have user forms listed in VBA. I am not sure how you were able to ********* your version. They only way to get on the Mac is either with Excel 2011 or with a Windows version running on VM. It would be nice if they were working on this but I have a bad feeling that they have no intentions of working on it since this case has been open since 2016 came out. I would think we would have something by now if they really intended on adding it. It really is sad when they don't seem to respect the Mac community as much as the Windows community.
I'm on the Office Insider option, but I've had the form option for over a year since Sept last year and it seems to be very slowly getting there hope this helps
Alain Thibault commented
@Dudley, what IOS version do you have? When I am trying to update Excel the software is saying that I am up to date and my version is of Excel is: 16.16.11.
How can you be at 16.27?
It seems that all may not be lost, I hope that this screen shot shows that the Excel team may be working on form.
I was able to make a very basic form and run it however I could not edit it
My Excel ver is 16.27
Hi Steve L,
What is your objection about my comment below ? (June 12th) Or do your agree with the fact that a rich userform is basically incompatible with VBA on Mac ?
Steve L commented
Really need to be able to use Userforms in the VB Editor on Excel for Mac... Any ideas if this is in development or when it might be released?
It appears to me today that useful userforms are theoretically impossible in VBA / Excel for Mac. Let's see why. After this source
" Both types of controls can be used on worksheets but only ActiveX controls can be used on userforms. "
From elsewhere, we also know that ActiveX controls aren't known on a Mac.