The attachment is a workbook that uses a userform to input data into an array on the spreadsheet. This allows a "carriage-return" type of entry when there are a large number of rows.
The array can be positioned anywhere on the s/s by using the "settings" form and can also be set for entering data row-wise or column-wise and there is also an editing mode for where mistakes are made.
The actuating macro is "ShowForm" but there is also an "array" button assigned to the toolbar in the workbook to actuate it. Bas and frm files are enclosed for those wanting to import it into an existing workbook.
I will be interested to know if the symbols (i.e. presswriter symbols - up, down, left, right arrows) on the edit buttons display correctly on later versions of office (I'm using '97).
The only real drawback is (if you don't want to use the mouse) that you need to hit the enter key twice to enter data. Is there a simple way to change this?
This started as a simple question about using textboxes to input data for an array but I decided to enlarge on it (just for the hell of it)
(THESE PROBLEMS HAVE ALL BEEN RESOLVED NOW, PLEASE GO TO THE LAST POSTING FOR A BETTER VERSION)