topic AW:Creating a multiple choice message box with macro in QlikView

Creating a multiple choice message box with macro

Mon, 07 Jun 2010 12:05:19 GMT

Hi I've just created a message box in Edit Module dialog in QV.

sub DisplayMessage

msgbox "text"

end sub

Very Simple script and i Exucute it by pushing a button in QV.

But Now to my question; I Want, in the box that's diplayed for the user, to have two chioses. Simply "Yes" and "No". So the user can decide whether if hi/she wants to exicute the export, in this matter, or not. As it is now You can only click "OK".

Someone got any ideas?

AW:Creating a multiple choice message box with macro

biester — Mon, 07 Jun 2010 12:31:14 GMT

That's not so much a QlikView problem, it's VBScript. Just use the parameters of the MsgBox-Function, e.g.:

Sub DisplayMessage
'this displays a Yes / No message box
Answer = MsgBox("Do it or not?",4,"Title")
If (Answer=6) Then
..........
Else
........
End If
End Sub

A documentation of MsgBox can e. g. be found here: http://www.w3schools.com/VBScript/func_msgbox.asp

Rgds,
Joachim