programatically creating dialog box
 

Hi,
How do you programatically create a dialog box? I can figure out how
to do it with the C based API, but can't figure it out with the COM/OLE
API from Visual C++. The documentation says, there is a DialogBox
method on a range object from a macro sheet, but how do I
programmatically create an in memory only range object to use? Or is
there another way of doing this? Is the only way to use the DialogBox
method from a precreated macro sheet?

Thanks,
Omri

programatically creating dialog box
 

You can see an example of the dialog in use on John Wakenbach's site:
http://www.j-walk.com/ss/excel/tips/tip48.htm

Regards
Rowan

" wrote:

Hi,
How do you programatically create a dialog box? I can figure out how
to do it with the C based API, but can't figure it out with the COM/OLE
API from Visual C++. The documentation says, there is a DialogBox
method on a range object from a macro sheet, but how do I
programmatically create an in memory only range object to use? Or is
there another way of doing this? Is the only way to use the DialogBox
method from a precreated macro sheet?

Thanks,
Omri