Home

Problemas con el Editor de Visual Basic en Excel 2016 para Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-758114%22%20slang%3D%22es-ES%22%3EIssues%20with%20the%20Visual%20Basic%20Editor%20in%20Excel%202016%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758114%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CSPAN%3EI%20have%20a%20MacBook%20Pro%20with%20the%20OSX%20Catalina%20in%20Beta%20version%20and%20am%20using%20Office%20365%20version.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20not%20an%20expert%20in%20Excel%20and%20less%20in%3CBR%20%2F%3EVBA%20in%20Excel%2C%20but%20I%20have%20the%20following%20problem%3A%20I%20am%20developing%20an%20application%20for%20my%20students%20in%20Excel%202016%20for%20Mac.%20The%20app%20has%20objects%20like%20the%20following%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123475i61FE00234F1EAAE1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screenshot%202019-07-03%20at%2011.54.58%20a.%26nbsp%3BM..%20Png%22%20title%3D%22Captura%20de%20Pantalla%202019-07-03%20a%20la(s)%2011.54.58%20a.%26nbsp%3Bm..png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20file%20was%20initially%20created%20in%20Excel%20for%20windows%20but%20I'm%20trying%20to%20finish%20it%20on%20the%20Mac.%20However%2C%20when%20you%20open%20the%20Visual%20Basic%20Editor%2C%20I%20see%20that%20the%20following%20option%20is%20disabled%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20368px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123474i816156920172F59F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screenshot%202019-07-03%20at%2011.52.55%20a.%26nbsp%3BM..%20Png%22%20title%3D%22Captura%20de%20Pantalla%202019-07-03%20a%20la(s)%2011.52.55%20a.%26nbsp%3Bm..png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20fact%20that%20this%20option%20is%20disabled%20prevents%20me%20from%20seeing%20the%20objects%20and%20their%20corresponding%20code.%20I've%20already%20reinstalled%20Office%20365%20in%20two%20occasions%2C%20complete%2C%20from%20scratch%20and%20the%20problem%20isn't%20solved%2C%20it%20doesn't%20activate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20any%20idea%20why%20this%20is%20happening%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20very%20grateful%20for%20the%20help%20you%20can%20give%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJorge%20A.%20Echeverri%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-758114%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-758291%22%20slang%3D%22en-US%22%3ERe%3A%20Problemas%20con%20el%20Editor%20de%20Visual%20Basic%20en%20Excel%202016%20para%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758291%22%20slang%3D%22en-US%22%3E%3CP%3EJorge%2C%3C%2FP%3E%0A%3CP%3EI%20was%20quite%20impressed%20with%20how%20well%20Bing%20Translate%20handled%20the%20translation%20of%20your%20Spanish%20inquiry%20into%20English.%20I%20hope%20that%20it%20does%20equally%20well%20for%20you%20in%20the%20other%20direction.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMac%20Excel%202016%20(including%20VBA)%20was%20completely%20rewritten%20to%20use%20the%20Cocoa%20API%20instead%20of%20the%20older%20Carbon%20API.%20At%20initial%20release%2C%20the%20VBA%20IDE%20in%20Mac%20Excel%202016%20was%20missing%20so%20many%20features%20you%20could%20do%20little%20more%20than%20debug%20code%20written%20in%20Windows%20Excel%20(or%20Mac%20Excel%202011).%20If%20you%20have%20Office%20365%2C%20many%20of%20the%20missing%20features%20were%20restored--but%20not%20all%20of%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20the%20Office%20Insider%20release%20of%20Mac%20Excel%202016%2FOffice%20365.%20It%20is%20more%20recent%20than%20your%20version%2C%20but%20the%20middle%20icon%20is%20still%20grayed%20out.%20On%20Windows%20Excel%20VBA%2C%20that%20icon%20returns%20you%20to%20the%20worksheet.%20In%20Mac%20Excel%202016%20VBA%2C%20I%20click%20the%20yellow%20circle%20at%20the%20top%20left%20corner%20of%20the%20VBA%20window%20to%20minimize%20it%20and%20accomplish%20the%20same%20thing.%20Alternatively%2C%20if%20you%20leave%20a%20small%20portion%20of%20the%20worksheet%20window%20exposed%2C%20you%20can%20click%20on%20that%20to%20jump%20back%20to%20the%20worksheet.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20far%20left%20icon%20in%20Mac%20Excel%202016%20VBA%20does%20take%20you%20to%20the%20code%20for%20the%20selected%20object.%20This%20was%20a%20feature%20I%20had%20never%20noticed%20before%20in%20either%20Windows%20or%20Excel%20VBA.%20My%20habit%20is%20to%20doubleclick%20the%20gray%20module%20icon%20in%20the%20Project%20Explorer%20(shaded%20gray%20in%20screenshot%20below)%20instead.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123489i477FFAEA53BF4B4D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-758817%22%20slang%3D%22es-ES%22%3ERe%3A%20Issues%20with%20visual%20basic%20editor%20in%20Excel%202016%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758817%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374823%22%20target%3D%22_blank%22%3E%40Brad_Yundt%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20Brad!%20%3CBR%20%2F%3EI%20appreciate%20very%20your%20response.%20I%20understand%20from%20the%20answer%20you%20give%20me%20that%2C%20because%20of%20my%20inexperience%2C%20I%20was%20not%20very%20clear%20with%20the%20question.%20I'm%20going%20to%20attach%20some%20screenshots%20from%20Excel%20for%20Windows%20in%20order%20to%20be%20clearer%20and%20help%20you%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20image%20you%20see%20below%20I%20show%20with%20circles%20and%20arrows%20the%20items%20that%20I%20can%20see%2C%20and%20also%20edit%20(code)%2C%20in%20Excel%20365%20for%20Windows%20but%20I%20CANNOT%20SEE%2C%20and%20LESS%20EDIT%2C%20in%20Excel%20365%20for%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20854px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123544i97E8B5D5EB51695B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Mac.png%20problem%22%20title%3D%22Problema%20Mac.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tell%20you%20that%20I%20went%20to%20an%20iMac%20computer%20computer%20computer%20room%20in%20my%20workplace%20to%20check%20if%20this%20option%20was%20available%20in%20the%20Excel%20there%20installed%2C%20and%20I%20could%20check%20that%20function%20is%20not%20active%20either%2C%20i.e.%20I%20can't%20SEE%20or%20EDIT%20my%20UserForm.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20image%20obviously%20gives%20you%20more%20clarity%20to%20help%20me%20and%20I%20appreciate%20your%20response%20again%20and%20hope%20you%20can%20get%20an%20idea%20about%20my%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGrateful%2C%20Jorge%20Echeverri.%3C%2FP%3E%3C%2FLINGO-BODY%3E
jaedcol
New Contributor

Tengo un MacBook Pro con el OSX Catalina en versión Beta y estoy usando la versión Office 365.

 

No soy un experto en Excel y menos en VBA en Excel, pero tengo el siguiente problema:
Estoy desarrollando un aplicativo para mis estudiantes en Excel 2016 para Mac. El aplicativo tiene objetos como el siguiente:

 

Captura de Pantalla 2019-07-03 a la(s) 11.54.58 a. m..png

 

El archivo inicialmente fue creado en Excel para windows pero estoy intentando terminarlo en el Mac. No obstante al abrir el Editor de Visual Basic veo que está inhabilitada la siguiente opción:

 

Captura de Pantalla 2019-07-03 a la(s) 11.52.55 a. m..png

 

El hecho de que esta opción esté inhabilitada me impide ver los objetos y su correspondiente código. Ya he reinstalado el Office 365 en dos oportunidades, completo, desde cero y el problema no se soluciona, no se activa.

 

¿Tienen alguna idea de porqué sucede esto?

 

Agradezco mucho la ayuda que me puedan brindar.

 

Jorge A. Echeverri

3 Replies

Jorge,

I was quite impressed with how well Bing Translate handled the translation of your Spanish inquiry into English. I hope that it does equally well for you in the other direction.

 

Mac Excel 2016 (including VBA) was completely rewritten to use the Cocoa API instead of the older Carbon API. At initial release, the VBA IDE in Mac Excel 2016 was missing so many features you could do little more than debug code written in Windows Excel (or Mac Excel 2011). If you have Office 365, many of the missing features were restored--but not all of them.

 

I have the Office Insider release of Mac Excel 2016/Office 365. It is more recent than your version, but the middle icon is still grayed out. On Windows Excel VBA, that icon returns you to the worksheet. In Mac Excel 2016 VBA, I click the yellow circle at the top left corner of the VBA window to minimize it and accomplish the same thing. Alternatively, if you leave a small portion of the worksheet window exposed, you can click on that to jump back to the worksheet.

 

The far left icon in Mac Excel 2016 VBA does take you to the code for the selected object. This was a feature I had never noticed before in either Windows or Excel VBA. My habit is to doubleclick the gray module icon in the Project Explorer (shaded gray in screenshot below) instead.

image.png

@Brad_Yundt 

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.

 

Problema Mac.png

 

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

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies