VBA User Form - Linking Close Button and Cancel Button

Dear Friends,

I have created a Userform with following buttons,

1.Design
2.Cancel
3.Help
4.Clear Form

During the process if I press Cancel button to Stop execution I have prepared the vba code to request for confirmation. When I click on the "Close" button at the right top corner of the window, it doesn't request any confirmation. In such case, How can I interlink my "Cancel" button and "Close" button.


Thanks in advance

or you can force the use of the cancel option button

Please Login or Register  to view this content.

or run the commandbutton code

Please Login or Register  to view this content.