You SP myStoredProcedure should return an output parameter value.
specify the return value in SQL Server SP after the insert as
return @@IDENTITY
This completes one part. Now in VB code use command object to execute the SP.
specify output Parameters for the command. When you execute the command, the parameter automatically contains the value of SP's output parameter.
Best Luck..
Nilesh