Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA multi line expressions

Status
Not open for further replies.

cadoltt

Programmer
Joined
Jun 9, 2005
Messages
85
Location
CA
Hi everybody,

In my VBA program I need to pass quite a few parameters to a function, so the line might be too long to fit into screen.

Say, this is:

myFunc(param1,param2,param3,param4)


Can I do something like this:

myFunc(param1,
param2,
param3,
param4)
?

I tried ' _' and ' & _' at the end of the lines but they don't seem to work.


Anything wrong with such a syntax?

Thanks,

Alex
 


Hi,

SPACE UNDESCORE
Code:
myFunc(param1, _
param2, _
param3, _
param4)

Skip,

[glasses] [red][/red]
[tongue]
 
Works now,

Thank you, Skip!

Alex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top