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)
Anonymous
shared this idea
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]
186 comments
-
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.
-
Patrick
commented
Thank you Dudley, that link was very informative and appreciated.
-
Dudley
commented
Hi Patrick
Sorry for the delay I have been extremely busy anyway check this link out. look for the reply from Schwieb
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/filelen-command/c8da4359-3fda-4c92-be8e-96dcc4282299 -
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.
-
Crigou
commented
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).
-
Patrick
commented
Hey Dudley,
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. -
Dudley
commented
Hi Alain
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?
-
Dudley
commented
Hi All
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 -
Crigou
commented
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
Hi,
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?
Thanks
Steve.
-
Crigou
commented
Hi gentlemen.
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.
Q.E.D. -
Mitch
commented
Do we build websites & databases, or Microsoft Excel's VBA UserForms? It was a decision we had to make.
I still develop in Excel's VBA. It was the first language I learned to use, 19 years ago.
I've moved as much as possible to Google Sheets. No VBA support for creating and editing UserForms was the straw that broke the camels back at our company.
Since my team & I develop in Ruby, Python, and JavaScript, we choose Mac machines for the pre-installed Ruby, Python, etc. for developing the front-end of our websites & databases.
The internet is pretty popular in 2019. In the USA, more businesses use the internet than Microsoft.
Microsoft choosing this route, forced us to alternatives. The company is catering to the government(s) sector, that do not have to exchange goods & services for $. Apparently, Microsoft is all in on Asian governments.
R.I.P.
Mitch Hunt
Lead Data Architect -
David James
commented
This feature should be added to Excel 2016 as well as newer versions. People who bought 2016 thought they were buying an UPGRADE on 2011 but were scammed. If this is not possible then we should be able to get a FREE upgrade to the current version when it includes the various features removed in 2016.
Pigs will fly before any of this happens.
-
Crigou
commented
May be in Excel 2019 ?
-
Ron Abraham
commented
When will the User Form be added to Mac Excel 2016?
-
Crigou
commented
Hi anonyme.
What you are experiencing was already known about 2 years ago:
https://www.excelcampus.com/vba/vb-editor-mac-update/
when Jon Acampora wrote:
"
...You can run userforms on the Excel 2016 for Mac. They will just have to be developed in either a Windows version or Excel 2011.
…"
So bad about Excel on the mac.
-
Anonymous
commented
I have an old form that still works, but I can no longer edit it
-
Crigou
commented
Furthermore, no Extended Support for Excel 2016 / Mac seems being defined:
-
Robert Frießleben
commented
You can use instead of VBA and UserForms also JavaScript and HTML in Excel → it is called Office.JS. I suppose, this is the prevered way to implement Userforms in Office 2016 …
