Suggestions on Control type for Data Entry

[GH]

I have a multipage Userform whose purpose is to facilitate some data
entry.

I also have a two dimensional array (15 x 4) that is filled via VBA by
reading the contents from another range in a excel file that is opened
by VBA and subsequently closed. Ideally, I would like to create a data
input section that fills in the data as contained in the array in a
similar "spreadsheet" format (like a multicolumn "listbox") but would
also allow for the user to change the contents from the displayed
default values. A multicolumn listbox is typically used to select a
row, not edit the contents of the rows.

Is my only option to create 60 textboxes and fill them with the default
values contained in the array?

Would appreciate the thoughts of those more sophisticated than myself.
GH

 

[Sharad]

You can have only Four text box, with command buttons both on left and
right side, showing arrows < and > respectively.
When loaded it starts with Array(1,1 to 4) and clicking and or > will
change the text box values to (2, 1 to 4).
The user can change the values in the text box, but after changing he
will have to click on another command button below having caption
'Save'. If he doesn't click on save and click on < or > arrow the next
array will be shown without changing the previous array.

All this said, the easiest way out would be use a database (may be
access) with ADO. ADO will do exactly what I said above, you need not
seperately add and code the arrow buttons etc.

Sharad


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!