In Excel, I use forms alot.

I now have a form based spreadsheet which i am considering moving into
visual studio to create a standalone application. This will take alot of
time, however I know I can export the forms into visual studio so that the
interface looks the same

However, my problem is getting my head around storing data/numbers in that
environment and then working with equations to deliver results and then acces
and store those numbers.

For example its easy in excel to reference particular cells on particular
sheets to access and deposit data/formulas/values and then excel does the
number crunching.

Can someone give me some pointers about how this is handled with vba outside
of excel - presumably one can use a database to store data and then access
particular row/column addresses, but what about formula calculations?

Can anyone give me some pointers as I consider this transition from Excel VBA

Many Thanks,

Roger