Are you saying that you want to use that long IF code constantly throughout your program? If so, put it in a private sub, then just call it when you want to use that code. So...
private sub water()
'put if code here
if y>1 and x<1 and z=1 then Q.caption="1"
Then whenever you want to use that code, just call the sub: