You can also control these other applications easily in your Visual Basic code. This section guides experienced users of Microsoft Excel 4.0 macros to information about learning and using Visual Basic. In Visual Basic, you make a range of text bold by just setting the Bold property of the range to True . More Powerful Than Names To store a value as a variable in Microsoft Excel version 4.0, you'd typically store the value in a name. In Visual Basic, you'd assign the value to a variable instead.
Variables are much more flexible than names.
You can make variables available to all procedures, to only the procedures in a given module, or to only a single procedure. You can control the type of data that can be stored in a variable, and you can even create variables that store a combination of data types of your choice. You can use the Application qualifier to run a Microsoft Excel worksheet function rather than a Visual Basic function. The following example successfully uses the Microsoft Excel worksheet function ACOS because the code first refers to the Application object. The only worksheet function that requires you to explicitly specify that you're referring to either the function's Microsoft Excel version or its Visual Basic version is the LOG function, because both function names are spelled the same way.