How to verify that the SSIS package ran successfully after running a VBA macro from Excel?

I have an Excel VBA macro which calls a stored procedure. The stored procedure calls a SQL agent, which in turn calls an SSIS package. All I need from the Excel VBA code is to ensure that the SSIS package ran successfully. How do you develop a VBA code to let the user know that the job either failed or succeeded after the user executes the Excel macro? Also, is there a need for a recordset in the VBA code?

Could it be as simple as setting a boolean? By fail, do you mean the procedure produced an error?

Yes, SSIS package failure.