Calling a function from VBA on mac

[Proxima17]

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]

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

[#3]

@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