You can't use ActiveX controls on a Mac, so that is not going to be particularly helpful to you. There is also still no userform designer so you won't be able to do any of that.

Developing on a Mac is frankly painful in current versions, and I don't see any prospect of that changing any time soon (it's been 6 years since they said they were working on a userform designer) given that Microsoft has no interest in VBA.