best method of storing data-VBA

[gr8trthanu]

I have a worksheet that when the right username is answered it goes into userforms (visual basic) On these forms I need to store, retrieve, and edit data. What is the best way to store data. Is it best to use sequential files using Input # 1 , Output # 1 and Append # 1. If there is a better way can some one point me in the right direction. I will also have to make some calculations and the variables or data

thanks in advance

 

[mikerickson]

In Excel, storing data in cells is easiest and leaves that data exposed to Excel's analysis tools.

 

[gr8trthanu]

Can I ask if you of a tutorial to store the data into excel
thanks for your help

 

[mikerickson]

The spreadsheet that you have has a Help system that is a valuable resource.

 

[gr8trthanu]

Sorry...I should have asked where can I find a tutorial on how to save to cells
my apologize

 

[jfklbj]

I prefer creating an array and then storing in a name such as:

Names.Add name:="StoredOverbill", RefersTo:=overbillData

Then you can retrieve the data later with a statement such as:

overbillData = [StoredOverbill]

This allows for quicker access and you don't need to mess with pasting the data into cells and than retrieving it through a loop.

 

[gr8trthanu]

Thanks...
do you know where I can find information on this. There are 80 boxes in total. Quite alot of data. I would like to read to understand it.

 

[jfklbj]

My source is Excel 2003 VBA Programmer's reference. Good luck!