Show me!!!

[Murali27]

Dear all,

I am new learning programmer.

In one of my project, i have to explain the use of a spread sheet by giving list of instructions as well as showing the range of cells parallely.

Can i get a control on run time so that in a series of time intervals i will be able to explain/show the procedure.

your input will be appreciated.

 

[BruceP]

Do you mean that you already have a functional spreadsheet and you need to explain how it works to your instructor?

I don't understand the range of cells requirement.

Are you trying to set up a series of individual time intervals that will execute for some period of time before ending so you can explain something during the execution period?

I think a longer post with more detail is in order.

 

[Murali27]

Yes you are right BruceP. I need to know how to have a control on the executing time of macro or any module so that i will be able to explain.

Hope you got my concern

 

[Binary]

A couple thoughts:

You could put a msgbox inside loops so that you can toggle the program through each loop.

You could use the timer function (search in here for recent threads)

You could use the debugging features which are very powerful and include the ability to monitor the values of variables, step through code one line at a time, put breakpoints in, etc.

I guess the question is, are you looking to explain you program to a teacher while (s)/he is looking over your shoulder at the computer? If so, the debugger is the best bet.