(a) Search XL VBA help (or I imagine Word VBA or PP VBA or Access VBA or...)
for 'loop' (w/o the quotes). One of the suggested topics will be
'Do..Loop' Look it up and you'll find the way to break out of a loop

(b) See the XL VBA topic 'Calling Sub and Function Procedures'

(c) Search XL VBA help for 'universal variable' (w/o the quotes). One of
the suggested topics will be 'Understanding the Lifetime of Variables'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article om, Shani718
@gmail.com says...
What statement can i use to break out of a loop?

how do i call a procdedure?

How do i declare a universal variable that all sub() can use?

appreciate the help. Thanks