• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 42. Working with Visual Basic fo... > Building Interactive VBA Programs

Building Interactive VBA Programs

Some macros work by themselves, with no user intervention required. The ItalicizeFirstWord macro, which you recorded in the previous chapter, falls into the “no hands required” category. It runs from start to finish and, except for starting it, the user doesn't have to do a thing. In fact, all recorded macros run without any user intervention, because the recorder doesn't have the intelligence necessary to know when to pause for user input when it's required.

More powerful macros interact with the outside world—for example, a macro might stop and let you select a file from a browse box, or display a message and wait for you to click OK. You can also set up timers to let a macro pause for a predetermined amount of time—to display a message without requiring the user to click OK, for example.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint