msgbox without stop the macro

[samisamih]

hi
i need to get the value of the array by msgbox in the macro event , without to stop running the macro , its is possible

the macro i wrote

Please Login or Register  to view this content.

the problem with the macro in the" msgbox arr(n1)" i need all the time to press ok to resume the macro again?
is there a way to get msgbox whithout to stop the macro running?

or all other way to display the array values apart from print the array value in the excel sheet cells?

thank in advance

[Arkadi]

I don't believe you can... but you could use the status bar? This would put the message in the status bar:

Please Login or Register  to view this content.

then later to clear it:

Please Login or Register  to view this content.

Alternatively you could create a userform that displays the message.

[samisamih]

only now i was test the statue bar its not useful for me because the statue bar will pause all update in the macro until the macro arrive" Application.StatusBar = False" also i want to see all the value for all the index infront of me .

its possible to print the value of the array and the index(n1) at the userform if i work with macro change event? if yes can you help me please

best regards

[LordLoki]

I would use debug.print instead of msgbox then you have everything in the immidiate window.

Another option would be to open a second form with a listbox\textbox or just add the textbox listbox for logging to your main form

[samisamih]

thank for your help
i test it with simple macro , but only there is small problem of sequencing data
i wrote the macro

Please Login or Register  to view this content.

the problem that the i get the result One under the other

i get the value of i and under it i get the value of k , and i get the value of m and under it i get the value of t

its possible to get the value of i and beside to get the value of m and beside the m to get the k and beside the t

and not one under the other

[NoSparks]

Why not state what you are trying to do and what the problem is ?

From your post at VBAexpress, it's hard to imagine a solution to what you ask here actually fixing your problem.

[samisamih]

I WROTE a macro and its work ok , i need only to print the result of the macro , i tried to print the results in a sheet cells , for example
cells(n1,3).value=arr(n1) and the problem that the value that printed in the cell is printed in delay and i miss data , Therefore i ask for a way to print the result of the macro "arr(n1)" in other place to git rid of the delay with print the data? and when i tried the msgbox (msgbox arr(n1) ) the data updated without delay, and i search soluation?