Hi, I found some code to display a status message box while running a long macro, so that the user knows the computer is busy. However, I'm having trouble implementing it. Specifically, once I've created 'Dialog1' in the Forms folder of my VBA Project, I can't seem to attach a macro to the dialog box frame, as requested by the website where I got the code:

http://j-walk.com/ss/excel/tips/tip01.htm

It asks me to highlight the frame and right-click it, and then choose Attach Macro, but I don't see that option. I'm using Excel v.X (2000) for Mac OS X.

I would like to call 'ShowDialog', have it call 'OnShow', and that one call my long macro 'Expand_Coded'. I guess I'm also confused about what 'OnShow' does and why it needs to be separate from 'ShowDialog'.

Thanks for your help.

> This is the text of the code from the above webpage:

Sub ShowDialog()
' This macro displays the dialog box
Dialog1.Show
End Sub

Sub OnShow()
' This macro is attached to DialogFrame of the dialog box
Call Expand_Coded
Call ShowDialog
ThisWorkbook.DialogSheets("Dialog1").Hide
SendKeys "~"
DialogSheets("Dialog1").Show
MsgBox ""
Dialog1.Hide

End Sub