topic Inputbox cancel-button in QlikView

Inputbox cancel-button

Fri, 22 Apr 2011 11:06:24 GMT

I am using the following in a macro:

filename = ActiveDocument.GetApplication.

InputBox("Enter name of the file to be saved", "C:\document.txt")

How can I detect if the cancel-button is used? Because I have a preset-value entered, LEN(filename) is still the length of "C:\document.txt". Also filename = False is not working etc.

Thanks, Nor

Inputbox cancel-button

Fri, 22 Apr 2011 11:54:54 GMT

Hi,

If user hits Cancel button, InputBox function returns empty string "".

This example works for me:

fname=InputBox("Enter your name","Userinput")

if fname = "" then

fname=InputBox("Try it once more!","Userinput")

end if

Hope this helps

Tomas

Inputbox cancel-button

Fri, 22 Apr 2011 12:08:19 GMT

Thanks for answering.

When I use the InputBox-function as you suggest, I have not found a way to already have an aswer pre-filled in in the inputbox. The other function has this possibility and I found this very usefull.

I've tested your solution and it is working, but not completely what I am looking for.

Nor

Inputbox cancel-button

Fri, 22 Apr 2011 13:37:58 GMT

If you want a predefined text allready in inbox, use third parametr. Cancel button has same functionality (returns "").

Example:


fname=InputBox("Enter your name","Userinput","Predefined text here:)")