Forum Discussion
Problemas con el Editor de Visual Basic en Excel 2016 para Mac
Hello Brad!
I very appreciate your response. I understand from the answer you give me that, because of my inexperience, I was not very clear with the question. I'm going to attach some screenshots from Excel for Windows in order to be clearer and help you help me.
In the image you see below I show with circles and arrows the items that I can see, and also edit (code), in Excel 365 for Windows but I CANNOT SEE, and LESS EDIT, in Excel 365 for Mac.
I tell you that I went to an iMac computer computer computer computer room in my workplace to check if this option was available in the Excel there installed, and I could check that that function is not active either, i.e. I can't SEE or EDIT my UserForm.
I hope this image obviously gives you more clarity to help me and I appreciate your response again and hope you can get an idea about my problem.
Grateful, Jorge Echeverri.
Jorge,
You may display userforms in Mac Excel 2016, but you cannot create them or edit how they look. Neither can you change the properties of the UserForm or any objects on it using the Property window. You can, however, edit the code for those userforms.
Until Microsoft developers get around to eliminating this gap, you should build your userforms using Windows Excel and then test whether they display properly on your Mac.
I run Windows Excel on a Parallels Virtual Machine on my Mac, and have done so for years. Code runs at perhaps 75% of the speed of a Windows computer. If I am satisfied with how fast code runs on my virtual machine, I know that my customer will be happy, too.
Brad