catch Return value from storeproc

[Mark_Meng]

Can some one tell me how to catch the return value from store procedure in VB.

I have a storeproc as

create Procedure StoredProcedure2
select * from agent
return 5

I would like to catch the 5 in my VB code, can someone tell me how to do it? Thanks in advance