Calling a function from VBA on mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1301322%22%20slang%3D%22en-US%22%3ECalling%20a%20function%20from%20VBA%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301322%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20call%20functions%20from%20VBA%2C%20onto%20my%20excel%20worksheet%20(example%3A%20%3Dfunctionname)%2C%20but%20my%20functions%20that%20are%20coded%20in%20VBA%20are%20not%20appearing.%20I%20am%20a%20student%2C%20who%20was%20working%20on%20a%20Windows%20computer%20till%20COVID-19%20caused%20are%20classes%20to%20be%20at%20home%20(where%20I%20need%20to%20use%20a%20mac).%20I%20am%20trying%20to%20do%20it%20the%20exact%20same%20way%20it%20worked%20on%20windows%20for%20me%2C%20but%20it's%20not%20working.%20Macros%20(Subs)%20work%20just%20fine%20but%20a%20function%20won't%20appear.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1301322%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%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-1543728%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20a%20function%20from%20VBA%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F618692%22%20target%3D%22_blank%22%3E%40Proxima17%3C%2FA%3E%26nbsp%3Bdid%20you%20figure%20this%20out%3F%20I'm%20having%20the%20same%20issue.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560133%22%20slang%3D%22en-US%22%3ERe%3A%20Calling%20a%20function%20from%20VBA%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560133%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738972%22%20target%3D%22_blank%22%3E%40taylormorgant34%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyep%20I%20did%20figure%20it%20out.%20That%20initial%20window%20that%20pops%20up%20(where%20you%20type%20your%20code)%20isn't%20the%20window%20you're%20supposed%20to%20be%20using.%20Whenever%20you%20load%20vba%20go%20to%20the%20top%20bar%20and%20click%20on%20%22New%20Module%22%20and%20there%20it%20should%20work%20wherever%20you%20type.%20It's%20been%20a%20while%20since%20I%20was%20working%20on%20this%20stuff%20so%20hope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, 

 

I am trying to call functions from VBA, onto my excel worksheet (example: =functionname), but my functions that are coded in VBA are not appearing. I am a student, who was working on a Windows computer till COVID-19 caused are classes to be at home (where I need to use a mac). I am trying to do it the exact same way it worked on windows for me, but it's not working. Macros (Subs) work just fine but a function won't appear. 

2 Replies
Highlighted

@Proxima17 did you figure this out? I'm having the same issue. 

Highlighted

@taylormorgant34 

 

yep I did figure it out. That initial window that pops up (where you type your code) isn't the window you're supposed to be using. Whenever you load vba go to the top bar and click on "New Module" and there it should work wherever you type. It's been a while since I was working on this stuff so hope that helps