Resolved Excel Macro help

Excel 2002 (old but it works)

I need to develop a macro that will increment a control cell by a set value between 0 and 360, usually in 24 deg increments. It will be continuous and cyclic, meaning at 360 it becomes 0 and continues around again, till I stop it.

There are a set of cells that recalculate depending on the angle in the control cell, and that is graphed.

It would be nice if I can change values in some cells while the macro is running.

Any suggestions??

 

Hi, I know nothing about this subject, but the link I will post has at the bottom, a blog contact to the Author who may be able to help you.
http://office.microsoft.com/en-nz/h...they-are-and-why-to-use-them-HA010007210.aspx
Cheers Neil.

 

Thank you for that link.
Interesting reading.

 

Again, I need to re-ask the question, as the problem has become more immediate to me.
The link above, while very interesting, does not relate to my question directly.

How can I change cell values while a macro is running? The macro will loop continuously until a condition is met or I stop it.

 

Anything helpful in this link:
Wordware.Microsoft.Excel.Functions.and.Formulas.Excel.97.Excel.2003.Nov.2006.pdf
http://www.scribd.com/doc/175548793...and-Formulas-Excel-97-Excel-2003-Nov-2006-pdf

 

It would be very useful in general, but again, not specific to my present problem.
It is a very good treatise on Excel functions, but not macros.

Also the "free" PDF is missing about 1/2 the pages, and there is no indication of the cost of the download until you get into the process.

 

Have you tried the Excel Forum?

http://www.excelforum.com/

There is a sub-forum for Excel Programming / VBA / Macros

 

antik

Thank you for the reference. I will ask this question there.