Whats Next

In this chapter you learned many basic VBA terms and built-in tools that make it easier to write and troubleshoot VBA statements. You should now have a good idea of how the most common Microsoft Excel objects are organized and controlled. I tried to keep the descriptions down to an absolute minimum and focus on teaching you how to use your new language skills to gain control over Microsoft Excel immediately without writing procedures. For this reason, I focused on the Immediate window. Visual Basic procedures usually contain more than one line of code. In fact, they can become quite complex. Before you can start creating complete VBA procedures, you still need to learn a couple of things. For example, how can you save information returned by Excel so that your procedures can use it later? While entering instructions in the Immediate window, you learned how to question Excel for vital information. You got answers to questions such as "How many worksheets are in the active workbook?" or "What's the contents of cell A4?" Excel did not mind any of your "nosy" questions. As long as you phrased your question by following the strict VBA syntax rules, Excel gave you the answer. When you start writing your own procedures, you will need to know how to save Excel answers. In the next chapter, you will learn how to save this kind of information for later by using variables. You will also explore the topic of data types and constants.

0 0

Post a comment