Thread: Call Statement
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
James James is offline
external usenet poster
 
Posts: 542
Default Call Statement

I always assumed that the "call" statement was used for setting a macro to a
button/checkbox...etc

Private Sub CommandButton1_Click()
Call #Name
End Sub

"caldog" wrote:

I know that there is something that is call a 'call statement', but I do not
know how its work. In my code I duplicate about 10 lines in five different
sections of code. What I was wanting to do, was locate the code that I use
quite a bit in one section and then just ask for when I need it.

Thanks