Reply to thread

Message: [QUOTE="Roger on Excel, post: 6432146"] 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 [/QUOTE]