Need Help Please: EXCEL+Vb Programming Newbee Question
 

I bought a program that populates data in a excel spreadsheet. I
have numerous calculations and often the spreadsheet has certain
fields that do not calculate on occasion causing all my totals to be
wrong.

With that in mind I would like to do the calculations in vb which I
know very little about interfacing with excel...

Unfortunately excel does not allow me to force circular referencing so
it is impossible to do latch functions and one shot functions with it
which I really need.

So what I really need is a place to go where I can get help or some
examples on how to interface and communicate with the cells in excel
using vb as I do believe that would be the best solution and keep my
excel sheet calculations small compared to the monster it is now...

Any help on this would be very much appreciated...

thanks,
JJ

Need Help Please: EXCEL+Vb Programming Newbee Question
 

go to tools=options=Calculation tab and click Iterations.

This allows circular references and provides options for controlling it.

Do

Ctrl+Alt+F9

to force a full recalc.

--
Regards,
Tom


wrote in message
...


I bought a program that populates data in a excel spreadsheet. I
have numerous calculations and often the spreadsheet has certain
fields that do not calculate on occasion causing all my totals to be
wrong.

With that in mind I would like to do the calculations in vb which I
know very little about interfacing with excel...

Unfortunately excel does not allow me to force circular referencing so
it is impossible to do latch functions and one shot functions with it
which I really need.

So what I really need is a place to go where I can get help or some
examples on how to interface and communicate with the cells in excel
using vb as I do believe that would be the best solution and keep my
excel sheet calculations small compared to the monster it is now...

Any help on this would be very much appreciated...

thanks,
JJ