关于MessageBox的是使用说明

最新推荐文章于 2025-04-23 14:20:54 发布

最新推荐文章于 2025-04-23 14:20:54 发布 · 182 阅读

本文详细介绍了VBA中MessageBox函数的使用方法及参数配置。包括如何设置不同的按钮组合、图标类型以及默认按钮等，帮助读者更好地掌握MessageBox在实际应用中的灵活运用。

Application.MessageBox('Text' ,'Caption' ,MB_ICONINFORMATION)//!
Application.MessageBox('Text' ,'Caption' ,MB_ICONQUESTION)// ?
Application.MessageBox('Text' ,'Caption' ,MB_ICONERROR) //x

MB_ICONWARNING
MB_ICONINFORMATION
MB_ICONQUESTION
MB_ICONERROR

最后一个参数可为:三个常量相加的结果,这三个常量分别代表:
1.按钮
2.图标
3.默认按钮:
如:
Application.MessageBox('确认','你确认要册删除吗?',MB_YESNO+MB_ICONQUESTION+MB_DEFBUTTON2);

第一个数可取
MB_OK = $00000000;
MB_OKCANCEL = $00000001;
MB_ABORTRETRYIGNORE = $00000002;
MB_YESNOCANCEL = $00000003;
MB_YESNO = $00000004;
MB_RETRYCANCEL = $00000005;

第二个数可取
MB_ICONHAND = $00000010;
MB_ICONQUESTION = $00000020;
MB_ICONEXCLAMATION = $00000030;
MB_ICONASTERISK = $00000040;
MB_USERICON = $00000080;
MB_ICONWARNING = MB_ICONEXCLAMATION;
MB_ICONERROR = MB_ICONHAND;
MB_ICONINFORMATION = MB_ICONASTERISK;
MB_ICONSTOP = MB_ICONHAND;

第三个数可取
MB_DEFBUTTON1 = $00000000;
MB_DEFBUTTON2 = $00000100;
MB_DEFBUTTON3 = $00000200;
MB_DEFBUTTON4 = $00000300;