VBA Functions

If want to see a list of the functions available in the VBA language just type

vba.

in the code window

VBA_Tip_1

You don’t need to include vba. when using the function in code.

If you see a function with a $ in its name it means it returns a string (text) eg UCase$

VBA_Tip_2

(Thanks to John Walkenbach for this tip.)

Click here to see how you can run a Macro off a Quick Access Toolbar icon.

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.