topic Re: how to capture msgbox value with ok cancel option in QlikView

how to capture msgbox value with ok cancel option

sarathi_pm — Mon, 09 Jun 2014 14:27:32 GMT

Hi,

I am writing VB code in Qlikview and want to give the user the option to proceed or cancel .

I want to write something like this

If Msgbox ("Do you want to continue?", VbOkCancel) = VbOk then

...

else

End if

But this is not working in Qlikview. Does anyone know how to capture the messagebox output?

Thanks

Sarathi

Re: how to capture msgbox value with ok cancel option

alexandros17 — Mon, 09 Jun 2014 14:28:46 GMT

Use alerts in Tools menu ...

Re: how to capture msgbox value with ok cancel option

sarathi_pm — Mon, 09 Jun 2014 14:34:36 GMT

Hi . I want to execute the code based on a button click. When the user clicks on a button, a message box has to pop up "Do you want to continue?" OK, Cancel.

Based on what the user selects(OK or cancel), i have to do further logic.

Re: how to capture msgbox value with ok cancel option

alexandros17 — Mon, 09 Jun 2014 14:36:36 GMT

...but to continue what???

Re: how to capture msgbox value with ok cancel option

Gysbert_Wassenaar — Mon, 09 Jun 2014 14:39:59 GMT

iAnswer = Msgbox("Do you want to continue?", vbOkCancel, "Continue?")

If iAnswer = vbOk Then

Msgbox "You answered yes."

Else

Msgbox "You answered no."

End If

Re: how to capture msgbox value with ok cancel option

sarathi_pm — Mon, 09 Jun 2014 14:42:42 GMT

I have a qlikview document which has some charts. I have written Vb code to generate a powerpoint based on a button click.

AS of now, as soon as the user clicks the button, the power point is getting generated.

I want to give the user an option when the user clicks on the button " Do you want to create a PPT?" if the user clicks OK in the msgbox then the powerpoint will be generated, If user clicks NO, then the code will simply exit.