Why would you use the existing forms when Visual Studio gives you a far
richer forms capability.

Using Visual Studio is similar to using any form of automation. You connect
to an instance of Excel, either existing or new, open or add a workbook,
then access ranges in a nominated sheet. Once you have navigated through the
object hierarchy, it is just like coding in VBA.

But of course, Visual Studio requires far more setting up than VBA, all of
the interop stuff etc.

HTH

Bob


"Roger on Excel" wrote in message
...
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