MessageBox - simple problem

Billm · Apr 9th, 2002, 07:30 AM

I have a messageBox popup that works fine when the focus ( my cursor) is on Excel .. however .. if I am using another windows programme .. and the excel condition is met whereby the MessageBox should popup .. ie an alert .. then it doesnt .. instead the Excel icon just flashes at the bottom of the screen. When I click on Excel .. the messagebox appears.

Is there any way of making the messagebox popup on the excel worksheet even when I am in another application .. as users are missing this message .. which is understandable cos its not that apparent if they are busy.

Thanks
Bill

AJ · Apr 9th, 2002, 07:34 AM

Bit of a shot in the dark here, but see what happens if you put
Application.visible = False
to hide Excel before the msgbox code and then
Application.visible = True
afterwards to bring it back.

I'm guessing (wildly) that the msgbox will still have to appear somewhere even if the Excel application is not visible, and will therefore head for the very front of the screen.

Rgds
AJ

Mark O'Brien · Apr 9th, 2002, 07:41 AM

I don't know if this will work because I don't have a quick way to send data to excel externally.

Anyway, I would try putting a line like this before your msgbox:



Windows("Book1.xls").Activate

HTH

Apr 9th, 2002, 07:41 AM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I don't know if this will work because I don't have a quick way to send data to excel externally. Anyway, I would try putting a line like this before your msgbox: Windows("Book1.xls").Activate HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 07:30 AM	#1
Billm Board Regular Join Date: Mar 2002 Posts: 83	I have a messageBox popup that works fine when the focus ( my cursor) is on Excel .. however .. if I am using another windows programme .. and the excel condition is met whereby the MessageBox should popup .. ie an alert .. then it doesnt .. instead the Excel icon just flashes at the bottom of the screen. When I click on Excel .. the messagebox appears. Is there any way of making the messagebox popup on the excel worksheet even when I am in another application .. as users are missing this message .. which is understandable cos its not that apparent if they are busy. Thanks Bill

Apr 9th, 2002, 07:34 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Bit of a shot in the dark here, but see what happens if you put Application.visible = False to hide Excel before the msgbox code and then Application.visible = True afterwards to bring it back. I'm guessing (wildly) that the msgbox will still have to appear somewhere even if the Excel application is not visible, and will therefore head for the very front of the screen. Rgds AJ