Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation and close
i was wondering if it is possible to insert vb code in a macro that wil
display to the user "are u sure u want to do this" or along thos lines, if yes the rest of the macro is executed else the macro stops. also i want to get rid of the 'X' at the top right of my form so th user cannot close the form is this possible any help would be appreciated And -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation and close
Andy,
try this: Sub Sure() If MsgBox("Are you sure you want to ****inue ?", vbYesNo, "Countinue ?") = vbNo Then Exit Sub 'Go on with the code which has to be executed here MsgBox ("You decided to continue") End Sub "bigandyt " schreef in bericht ... i was wondering if it is possible to insert vb code in a macro that will display to the user "are u sure u want to do this" or along those lines, if yes the rest of the macro is executed else the macro stops. also i want to get rid of the 'X' at the top right of my form so the user cannot close the form is this possible any help would be appreciated Andy --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation and close
Hi Andy
Sub Dothings() MsgBox "I work" If MsgBox("Continue ?", vbYesNo + vbQuestion) = vbNo _ Then Exit Sub MsgBox "Still working" End Sub As for the form X, is it userform. Will disabling it do ? http://j-walk.com/ss/excel/tips/tip80.htm If not it needs some quite heavy windows techniques, see FormFun at http://www.bmsltd.ie/Excel/Default.htm HTH. Best wishes Harald "bigandyt " skrev i melding ... i was wondering if it is possible to insert vb code in a macro that will display to the user "are u sure u want to do this" or along those lines, if yes the rest of the macro is executed else the macro stops. also i want to get rid of the 'X' at the top right of my form so the user cannot close the form is this possible any help would be appreciated Andy --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation and close
Hi Andy
If MsgBox("Are you sure you want to do this?", vbYesNo + vbsuestion, "Please confirm") = vbNo Then Exit Sub MsgBox "not cancelled" 'do your stuff To prevent closing your form add this into the form's code: Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode < 1 Then Cancel = 1 End Sub HTH Cordially Pascal "bigandyt " a écrit dans le message de ... i was wondering if it is possible to insert vb code in a macro that will display to the user "are u sure u want to do this" or along those lines, if yes the rest of the macro is executed else the macro stops. also i want to get rid of the 'X' at the top right of my form so the user cannot close the form is this possible any help would be appreciated Andy --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
confirmation and close
Sorry please amend :
If MsgBox("Are you sure you want to do this?", vbYesNo + vbQuestion, "Please confirm") = vbNo Then Exit Sub Pascal "papou" a écrit dans le message de ... Hi Andy If MsgBox("Are you sure you want to do this?", vbYesNo + vbsuestion, "Please confirm") = vbNo Then Exit Sub MsgBox "not cancelled" 'do your stuff To prevent closing your form add this into the form's code: Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode < 1 Then Cancel = 1 End Sub HTH Cordially Pascal "bigandyt " a écrit dans le message de ... i was wondering if it is possible to insert vb code in a macro that will display to the user "are u sure u want to do this" or along those lines, if yes the rest of the macro is executed else the macro stops. also i want to get rid of the 'X' at the top right of my form so the user cannot close the form is this possible any help would be appreciated Andy --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bookkeeping-payment confirmation | Excel Discussion (Misc queries) | |||
Confirmation Security | Excel Worksheet Functions | |||
A question about the confirmation | Excel Discussion (Misc queries) | |||
Confirmation ID provided? | New Users to Excel | |||
Getting rid of confirmation boxes | New Users to Excel |