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...

Code:
'declare sub
private sub water()

'put if code here
if y>1 and x<1 and z=1 then Q.caption="1"

end sub

Then whenever you want to use that code, just call the sub:

Code:
call water()