1181
Secrets of the Office Masters: Custom Dialog Boxes in VBA
Troubleshooting
Missing Personal.xls
I’ve looked in the Project Explorer, but I can’t find my Personal Macro Workbook.
If you don’t have a Personal Macro Workbook (stored as Personal.xls), the simplest way to
create one is to flip back to Excel and record a do-nothing macro: click Tools, Macro,
Record New Macro, and make sure you choose Personal Macro Workbook in the Store
Macro In box. Click OK, and then click the Stop button. Excel automatically creates
Personal.xls to store the recorded macro.
Different Buttons in Message Boxes
I want to create a message box similar to the one in Figure ...