Mostrar Cuadro de mensaje MsgBox con botones Sí / No antes de ejecutar una macro en Excel VBA
112.6 هزار بار بازدید -
6 سال پیش
-
✅ Download the file |
✅ Download the file | http://www.exceleinfo.com/mostrar-cua...
🏆 Subscribe | https://goo.gl/M5zNA8
In the VBA language and practically in any programming language it is necessary to master a function that allows us to both display informative messages and messages where we are given the option of continuing with the execution of a procedure or performing another action. In VBA there exists the MsgBox function that can be used only to display a message as to use it in conjunction with a variable and pass to the variable the value of the button that was pressed.
Overview of the MsgBox function in VBA
The use of the MsgBox function in VBA can be as simple or as elaborate as you wish. The following is the basic syntax of the use of MsgBox:
MsgBox [message], [buttons], [title], [help file], [context]
Now we see the use of MsgBox in a functional case:
Sub Mensaje()
MsgBox "Mensaje de prueba", vbOKOnly + vbInformation, "EXCELeINFO"
End Sub
More examples | http://www.exceleinfo.com
More examples | http://blogs.itpro.es/exceleinfo
Facebook Page | Facebook: EXCELeINFO
Get notificacions on Telegram | https://t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
http://addin.exceleinfo.com
🏆 Subscribe | https://goo.gl/M5zNA8
In the VBA language and practically in any programming language it is necessary to master a function that allows us to both display informative messages and messages where we are given the option of continuing with the execution of a procedure or performing another action. In VBA there exists the MsgBox function that can be used only to display a message as to use it in conjunction with a variable and pass to the variable the value of the button that was pressed.
Overview of the MsgBox function in VBA
The use of the MsgBox function in VBA can be as simple or as elaborate as you wish. The following is the basic syntax of the use of MsgBox:
MsgBox [message], [buttons], [title], [help file], [context]
Now we see the use of MsgBox in a functional case:
Sub Mensaje()
MsgBox "Mensaje de prueba", vbOKOnly + vbInformation, "EXCELeINFO"
End Sub
More examples | http://www.exceleinfo.com
More examples | http://blogs.itpro.es/exceleinfo
Facebook Page | Facebook: EXCELeINFO
Get notificacions on Telegram | https://t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
http://addin.exceleinfo.com
6 سال پیش
در تاریخ 1397/05/04 منتشر شده
است.
112,668
بـار بازدید شده