R
Rominall
I'm new to using arrays, so not quite sure if I'm headed in the right
direction.
I have a user form that will collect up to 10 records with about 5 fields.
instead of loading the data into the workbook after each record I thought I
might be able to use an array, as the user might want to edit the records
before they actually store them.
At a high lievel, what would be the best way to do this?
I was thinking something along the lines of an 10 X 5 array (there probably
won't ever be an instance of more than 10 records, usually less), and then
adding to the array each time the user hits 'next record'. When they click
'view current' then populate a list box or something with the current array.
And when they hit 'eccept' then populating the worksheet. I have a few
questions about this approach, how do I handle clearing the array when they
want to start a new set?, How do I handle when they want to edit records in
the array before storing?
I've read some stuff on MSDN library and visited Chip Pearson's website but
I'm stull just a little confused on how array's work.
Thanks in advance for any help, direction you can give me.
direction.
I have a user form that will collect up to 10 records with about 5 fields.
instead of loading the data into the workbook after each record I thought I
might be able to use an array, as the user might want to edit the records
before they actually store them.
At a high lievel, what would be the best way to do this?
I was thinking something along the lines of an 10 X 5 array (there probably
won't ever be an instance of more than 10 records, usually less), and then
adding to the array each time the user hits 'next record'. When they click
'view current' then populate a list box or something with the current array.
And when they hit 'eccept' then populating the worksheet. I have a few
questions about this approach, how do I handle clearing the array when they
want to start a new set?, How do I handle when they want to edit records in
the array before storing?
I've read some stuff on MSDN library and visited Chip Pearson's website but
I'm stull just a little confused on how array's work.
Thanks in advance for any help, direction you can give me.