Thread: ByRef v ByVal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jennifer Murphy Jennifer Murphy is offline
external usenet poster
 
Posts: 2
Default ByRef v ByVal

It is my understanding that I should use the ByVal keyword if I am
planning to modify the parameter. Is that correct?

Example:

Public Sub Write2File(byval FileID As String, Data As String)

FileID = FileID & ".txt"

....