Hi!

I want the user of my app to be able to enter data in fields the same way as in excel or in access. What is the best (easiest) control to use? (No third party controls please). The data must be at leat 4 "columns" wide (I prefer somthing to be expandble to 5 or more columns). Some columns will contain text, other numeric-values. (Although they could be converted by Val() or so...)

Here are my considerations so far:

  • The Listview?
    (Can't edit more than first column?)
  • DBGrid?
    (Too Complex)
  • Lots of textboxes in an array?
    (Too Complex, can be done easier I think)
  • Excel/Access Add-in?
    (Too heavy on resources)


Anyone any good ideas?