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?

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.