Msgbox from Access code but for Excel 1

[franksirvent]

Hi there

I have a code which creates a complex excel sheet from Access.
After formatting etc the Excel Sheet, i want a MessageBox to pop up advising that "the process is finished."

However, although the Excel sheet has the focus at all times (and users can see how it is being formatted etc etc, the msgbox does come up BUT in the Access application.
So Users cannot see it. They have to click on the Access App. in able to see it.
Can anyone advise how to make sure the Message Box comes out on the Excel Sheet, right after all the processes is finished ????

thanks

 

[Hap007]

Hi Frank,

Trial and error until you get what you want.

I doubt the standard 'Access' MsgBox function will ever show.

Here are 2 suggestions
1) Create a form in Access and make it look like the message box that you want.
2) Set the form properties to 'Modal' True and 'Popup' True
3) Now open that for and see if it does what you want.

Second Suggestion:
1) Place VBA Code on the excel sheet.
2) Have that code call a form or MSGBOX in Excel
3) Call that code from MS Access.
or)
3) Some part of the Excel formating calls that code.

Hope this Helps,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[SkipVought]

Hi,

Create your own message using an Excel UserForm.

Skip,
[sub]
[red][/red]
[/sub]

 

[franksirvent]

hi there

thanks both for your input

The second option Hap007 advises works well so I'll stay with that.

Thanks again!