I have this huge form. When the user selects a line of business, the LOB control has a change event that populates the form with the appropriate coverages for that line.
This form can print out reports for a number of states, so I'm trying to automate the process of stepping through states, then through coverages. But I'm running into a problem.
If I change the value of the LOB control from VBA, it doesn't trigger the change event and the coverage section doesn't update. "No problem," I said to myself. "I'll just use SetFocus and SendKeys to manipulate the form."
It works, too, except that if I switch applications while the VBA is running (for example, if I decide to check in on the Rebel Forum), SendKeys happily sends its keystrokes to whatever the foreground application may be (for example, Internet Explorer).