Active X Control button validation

[Rob-UK]

Hiya! I have inherited a form that users then send to a BOT to be processed. The "submit" button opens Outlook and creates an email to the BOT, attaching the completed form.
I have applied various Data Validations to cells within the form and would like to add some VBA coding to check certain cells have been completed before the "submit" button is visible.
Through searching the internet, I have found various codings that seem to be what I want, but which do not work on the sheet!

I think the button is an 'ActiveX Control' button as opposed to a standard button, but am not 100% sure! In the coding that creates the email, it appears the button is called EmailFCCBOTControl()

Is there anyone out there that can help me figure out the correct type of coding I need? I can work out the validation, but for the purposes of this example, lets say it is Sheet1 and that I want to ensure that there is data is cells I21,I22,I24,I25 and that the value in cell L52 is 360 or less.

Thanks so much in advance!

Rob

 

[Rob-UK]

UPDATE - on the basis that when I right click on the Control button, it shows me Assign Macro, I believe this means it is not an ActiveX control but is a Form Control ?! (screenshot attached)

 

[Rob-UK]

Still struggling with this! In VBA the submit button appears to be referred to as Sub EmailFCCBOTControl() but when I select it on the sheet it shows a name of Button1 . Sure this is simpler than i'm making it !

 

[Jon Peltier]

The submit button has a macro assigned to it. Right-click on the button, and click on Assign Macro. It will show you a list of available macros, and the one in the top box will be the assigned one. Click Edit to view that macro in the VB Editor.

Then in the beginning part of this macro, test for values where they are required. If any are missing, use MsgBox to alert the user and then exit the sub before going to Outlook.