store procedure not run in vb 6 code

[kamendra]

Hi ,I have problem in vb 6.0 code.Actually one store procedure not execute in elseif condition in vb when i am trying to execute but no error.but it manually run in sql analyzer but through vb code it is running. i am writing this code following :
private sub cmdprocess_click()
Try :

On error goto catch
dim result as integer
cnn.commandtimeout=300
result=msgbox("do you wisht o process results" & vbcrlf &" modifications in the marks and cutoff will be locked",vbinformation+vbyesno)
if result=vbyes then
cmdprocess.enabled=false
frame2.visible=true
label13.caption="please wait while the results are being processed"
label3.refresh
progressbar1.value=progressbar1.value+10
if(cmbexamname.text="partB") THEN
StrSql="sp_insertresultPartB
elseif(cmbexamname.text="PartD") then
strsql="sp_insertresultPartD"
elseif(cmbexamname.text="DSSC/TSOC") then
strsql="sp_Entercimarks"
cnn.execute strsql
strsql="sp_scanningdssc"
end if
progressbar1.value=progressbar1.value+30
cnn.execute strsql
end if

in the above only sp_scanningdssc is not execute.control not reach at sp_scanningdssc.i think i am missing something.please help.its urgent