topic How do I stop a macro that this loop? in QlikView

How do I stop a macro that this loop?

Wed, 25 Apr 2012 14:42:08 GMT

Good morning everyone, I created a macro where it enters a loop (for) and I need this macro to be run when I click the button again how I do it?

How do I stop a macro that this loop?

Wed, 25 Apr 2012 17:09:04 GMT

I have this example of how to do macro loop to abort after the macro runs and there is some function that I can abort the macro. ??

set obj = ActiveDocument.GetSheetObject( "TX01" ) for RowIter = 0 to obj.GetRowCount-1 for ColIter =0 to obj.GetColumnCount-1 set cell = obj.GetCell(RowIter,ColIter) msgbox(cell.Text) next next

How do I stop a macro that this loop?

m_woolf — Wed, 25 Apr 2012 19:27:06 GMT

Do a Break (Ctrl + Pause)

How do I stop a macro that this loop?

Wed, 25 Apr 2012 19:28:59 GMT

Thanks it worked, would have as I put it on a button?

How do I stop a macro that this loop?

m_woolf — Wed, 25 Apr 2012 19:51:50 GMT

Use an Inputbox instead of a msgbox:

sub test
     for i = 1 to 100000
          Input = InputBox(i & " Type Q to quit")
          if Input = "q" or Input = "Q" then exit sub
     next
end sub

How do I stop a macro that this loop?

Wed, 25 Apr 2012 20:10:13 GMT

thank you