At one point in my program, if there is an error I need to show a customized form that allows the user to make necessary changes to some data. The code needs to be paused until the user is finished and closes the form. In Access, it is very easy to show a form dialogue-style, but in Excel I can't find any such method. When I show a form the code always keeps running in the background. Any way around this?
Tekito 0 Junior Poster in Training
QVeen72 104 Posting Shark
Hi,
use Sleep API, or
Application.Halt
Regards
Veena
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.