Here's our Microsoft Office Tip for.. June 2, 2003
Click Here to see a complete list of all of our previously released Tips!
Quick Constants
A number of function arguments are limited to a few intrinsic constants. Fortunately, as you're entering the function, VBA displays the possibilities for you.

Occasionally, however, you may need to know a constant's literal value. You could launch the Object Browser and find the value there, but VBA offers an easier way. Once you've added the constant to your code, simply right-click the constant and then choose Quick Info from the context menu. VBA will display the constant and its literal value.