Is there a break statement in VBA
 

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

Is there a break statement in VBA
 

(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

Is there a break statement in VBA
 

"Shani" wrote in message
ps.com...
What statement can i use to break out of a loop?

Exit For / Do / While

how do i call a procdedure?

Call MyProc()

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

Lookup "Public statement" in VBE help

appreciate the help. Thanks

My pleasure :)

Is there a break statement in VBA
 

In article ,
says...

{snip}

My pleasure :)



Hopefully, you will also the credit for the homework. {grin}

--
Regards,

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

Is there a break statement in VBA
 

Go to the top of the class Tushar :)!
John

"Tushar Mehta" wrote in message
om...
In article ,
says...

{snip}

My pleasure :)



Hopefully, you will also the credit for the homework. {grin}

--
Regards,

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

Is there a break statement in VBA
 

If using a universal variable (static, public), be sure to exit your
procedure by falling thru the "End Sub" or using and "Exit Sub". The "End"
statement resets variables.

"Shani" wrote:

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