Dialog Box interferes with spreadsheet display

Posted by Calvin R. Conn on January 30, 2000 9:14 PM

I use a dialog to get parameters for getting data from a
database. How can I close it before I run the gathering of
data. I now use an OK button on the dialog to start.

Posted by Calvin R. Conn on February 01, 2000 12:16 PM

The answer to this was staring me in the face and I
missed it. All I had to do was put:

Sheets(sSheetName).Activate

,in the procedure getting the data and the sheet
would repaint itself without the box.