2nd Line in VBA coding 1

[AmritPaulSingh]

If the VBA code has a very long line, how do i break it in 2 or more lines. I know there is something to do with & _ but am not able to use it.
Thanks

 

[dyarwood]

The thing you are loking for is

_

space then _ then just keep typing on the next line

 

[AmritPaulSingh]

Thanks dyarwood.

 

[nicsin]

if you just want to insert a line then you should use

_

. If you are also concatenating strings etc then use

& _

(notice the sapce in between).

public function myFun(param1 as string _
                      param2 as integer) as String
    Dim result as String

    result = param1 & _
             param2

    myFun = result
end function

 

[AmritPaulSingh]

got it.
thanks nicsin