The demo application MfcTutorial contains an example of an MFC dialog, CLanguageDialog. The example code below shows how to call this dialog when the add-in is opened.
BOOL CMfcTutorialApp::OnXllOpenEx() { // Create an instance of CExcelWnd CExcelWnd wndParent; // Create a dialog whose parent is Excel's application window CLanguageDialog lang(&wndParent); // Show the dialog and fail if the user cancels if (lang.DoModal() != IDOK) return FALSE; // Read the user's input from the dialog m_nLanguage = lang.m_nLanguage; return TRUE; }