Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Thursday, February 21, 2008 – Permalink –
VBA, Named Arguments
An easier read
MsgBox(prompt[, buttons] [, title] [, helpfile, context])
When you work the MsgBox function this way, the order of the arguments can't be changed.
Therefore, if you want to skip an optional argument that's between two arguments you're defining, you need to include a blank argument, such as:
MsgBox "Hello World!", , "My Message Box"
Named arguments allow you to create more descriptive code and define arguments in any order you wish. To use named arguments, simply type the argument name, followed by :=, and then the argument value.
For instance, the previous statement can be rewritten as:
MsgBox Title:="My Message Box", _
(To find out a function's named arguments, select the function in your code and press [F1].)
See all Topics
<Doug Klippert@ 8:00 AM
Comments: Post a Comment