Excel 2013 and Excel version 2015 Macros compatibility problem

Hello there, im experiencing problems in using Macros in Mac OS Excel platform. I actually created a userform on Excel enabling data entry in terms of name, department and costing to be inserted directly on an Excel sheet database as backup but when i try to use the same on a Mac OS Excel Platform, the user form button generating the database directly into Excel becomes a mere text box, i have to manually step into the macro to activate it and it also disables the department listing in the dropdown menu of the userform which works just fine on Windows Excel 2013. I would please like to have your views and suggestion on this problem. Is it better to use O365 in this case as the excel sheet containing the userform shall be shared across devices or is there any other solution to that? Thank you.