View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Calling msgbox in Excel

You would have to call a macro or otherwise execute a macro in Excel (written
in VBA) that displays the message box. (and perhaps returns a value).

--
Regards,
Tom Ogilvy


"Ben" wrote:

Hi all,

I just starting using VS2002. Currently in my Excel XP development, I can
use the msgbox to have it display a message.

While I was experimenting with VS 2002 and the PIA, I was wondering how I
can cause Excel to display a msgbox instead of one from the VS 2002 code.
Displaying a msgbox from within VS2002 causes the msgbox to appear behind
Excel. Whereas I would like to code it in such a way in VS2002 such that
when I instantiate an instance of Excel I would like Excel to display a
msgbox so that it is on top/ in front of Excel instead of behind it. Any
ideas? Thanks.

Ben



--