Explain line of code related to ListBox

[YasserKhalil]

Hello everyone
What does this line of code mean?

Me.ListBox1.Column = Array(1)

and this line

Me.MousePointer = 11

and what if 11 is 0 what it refers to?

Thanks advanced for help

 

[Chihiro]

Hard to say without the code...

From just the snippet, looks like it's just adding 1 to row 1 col 1 of listbox...

11 = Hourglass shape for mouse pointer.
0 = default

 

[YasserKhalil]

Thank you very much for the useful information

Here's the attachement which contains these lines (I'm trying to study it to learn)
If possible I need some explanation of it

 

[Chihiro]

From my guess, the Array(1) is residual line from testing.
You can run the code without that line with no issues.

Mousepointer is used to track if the process is running and if it is running, then it will cancel out from closing the Userform when "x" is clicked.

Not sure what other portion you'd need help with.

 

[Chihiro]

FYI - Check the link for great post by Luke M about local window, immediate window and watch window. It's of great help in understanding how any code works.

http://chandoo.org/forum/threads/immediate-window-locals-window-watch-window.25357/#post-151862

 

[YasserKhalil]

Thank you very much Mr. Chihiro for the link
I know immedaite window and local window but these are not enough to get the whole code and the details of each line ..
Hope to explain important lines only not all lines