Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi M,
Try something like: '============= Public Sub Tester() Dim res As VbMsgBoxResult res = MsgBox(Prompt:="Do you wish to continue", _ Buttons:=vbYesNo, _ Title:="Continue?") If res = vbNo Then Exit Sub End If 'your code End Sub '<<============= --- Regards, Norman "Varne" wrote in message ... Hi When you merge cells MS Excel warns you and asks for your permissoin to continue. I like to have a similar facility when running a macro. I would like the box to ask me for a yes/no or a value? Could someone help me with VBA codes for doing that please? Thanks Varne M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dialogue Box | Excel Discussion (Misc queries) | |||
dialogue pop up | Excel Discussion (Misc queries) | |||
pop up dialogue box | New Users to Excel | |||
pop up dialogue | Excel Discussion (Misc queries) | |||
Dialogue Box | Excel Programming |