Forum Discussion
Proxima17
Apr 12, 2020Copper Contributor
Calling a function from VBA on mac
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
Sort By
- taylormorgant34Copper Contributor
Proxima17 did you figure this out? I'm having the same issue.
- Proxima17Copper Contributor
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