Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding message window
Does anyone know if it possible (and how ofcourse) to make a pop-up message
window in excel that operates on the (Macro-)button. It has to contain a choice option to operate the (macro-)button. If the (macro-)button is used I want to make add a window which contains a text saying: "are you sure you want to delete the last year?" CHOICHE OPTION: "YES" or "NO" The macro will be run (and remove the appropriate collumns) if yes is pressed and other wise return to the previous screen. |
#2
|
|||
|
|||
Dim Resp as long
resp = msgbox(Prompt:="Are you sure", buttons:=vbyesno) if resp = vbyes then 'user hit yes else 'user hit no end if Guido van Lammeren wrote: Does anyone know if it possible (and how ofcourse) to make a pop-up message window in excel that operates on the (Macro-)button. It has to contain a choice option to operate the (macro-)button. If the (macro-)button is used I want to make add a window which contains a text saying: "are you sure you want to delete the last year?" CHOICHE OPTION: "YES" or "NO" The macro will be run (and remove the appropriate collumns) if yes is pressed and other wise return to the previous screen. -- Dave Peterson |
#3
|
|||
|
|||
I assume by (Macro-)button you mean a command button inserted into the
sheet? Sub Button1_Click() Dim response As String response = MsgBox("Are you sure you want to delete the last year?"", vbYesNo, "Warning!") If response = vbYes Then [your macro] End If End Sub Best rgds Chris Lav "Guido van Lammeren" <Guido van wrote in message ... Does anyone know if it possible (and how ofcourse) to make a pop-up message window in excel that operates on the (Macro-)button. It has to contain a choice option to operate the (macro-)button. If the (macro-)button is used I want to make add a window which contains a text saying: "are you sure you want to delete the last year?" CHOICHE OPTION: "YES" or "NO" The macro will be run (and remove the appropriate collumns) if yes is pressed and other wise return to the previous screen. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The formula Watch Window in Excel should allow more than one row | Excel Worksheet Functions | |||
Check box and and formula | Excel Discussion (Misc queries) | |||
Getting an error message "Cannot shift objects off of sheet" | Excel Discussion (Misc queries) | |||
when opening excel I receive a message that says file can't be fo. | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions |