Excel VBA dialog with custom buttons

I would like to create a dialog box or message box in excel WITH using special button shortcuts, i.e. FIRST and SECOND. I would like this box to open when the file was first opened ... and does not allow the user access to the worksheet until they select FIRST or SECOND.

I can make a form, but I would prefer not to add a form, as it should be simple ... I remember doing something very similar in the days of VB6, but it was once.

+3
source share
1 answer

The MsgBox function does not support different names (other than those specified) for buttons, and neither the method nor the InputBox function will allow you to change the names of the buttons.

.

+5

Source: https://habr.com/ru/post/1731434/


All Articles