If your intention 'Code should stop here and let the user continue till the next if statement' is to have code wait for the user's input is impossible. The code will get executed sequentially and will allow user interaction only if it executed.
There are couple of workarounds:
1) Have the If's nested to your application logic. So on one execution, it will check all available paths
2) Have 'Exit Sub' statment, if you want to exit from that part and allow the user to continue (type more info)
VBA Tips & Tricks (http://www.vbadud.blogspot.com