Link VBA code to form control button?

[leopardhawk]

Hello forum friends, I have a complex workbook that runs perfectly on a Windows PC but because it contains two ActiveX buttons that launch user data input forms, one for personal data and the other for financial data, the workbook cannot be used on a Mac PC.

I have discovered in another post that if I remove the ActiveX buttons and instead use Form Control buttons, that my workbook could function on a Mac PC as well. I have created two Form Control buttons to replace the ActiveX controls but my problem is, how do I link the two new form control buttons to the existing VBA code that actually brings up the UserForms so users can input their data? When I right-click the new form control buttons, I have an option to 'Assign Macro' but I'm not sure what to do at this point. I'm pretty sure a Macro isn't the same as VBA code (geesh, what a noob I am) but what can I do so that users will still be able to use the workbook on a Mac PC?

Any suggestions are much appreciated. Thanks!

 

[GWteB]

You are welcome! In answer to your questions:
1) After assigning them to a button it's ok to change the subs declaration to Private, they will be invoked on button click anyway.
2) That depends on the actual macro settings of each individual user. If this setting needs to be adjusted, it only needs to be done once, and not for each workbook separately. If it's set to "Disable all macros with notification", which is the setting I and my co-workers use, user is able to run macros, but for files not yet registered as trusted, user has to give explicit permission to run macros when opening an .xlsm workbook (yellow warning bar).

 

[leopardhawk]

Okay, thank you very much!!