I may be totally out of my depth, but I need to do something I haven't tried before and need a few pointers.
About 10 years ago, I used to program Excel macros quite happily. I also have a background in Pascal, but the finer points of VB
are still a bit of a mystery to me, so bear with me.
I need to program a user interface screen that is linked to data (mainly text) in an Excel sheet. (It's quite possible that this would be easier in a DB, but it isn't and I don't have experience with Access programming either.) The client wants the screen to show rows of text which consists of a number of columns, eg:
Select indicators to examine:
Indicators NSP Policy Reform Market Forces Fortress World
Indicator 1 (text) (text) (text) (text) ?
Indicator 2 (text) (text) (text) (text) ?
Indicator 3 (text) (text) (text) (text) ?
As can be seen by the last row, there should be an option to add more rows. Also, at the end of each row is a check box. By leaving a box unchecked, the user can delete a row.
The question is: how do I program this using Excel VB
I am currently thinking of using the Forms, but the only obvious controls I can insert are text boxes and check boxes. However, the form has to be able to add and delete rows and, even more complex, support more rows that space allows. Therefore, I'll have to be able to have scroll bars so the user can move up and down the table to see all rows. Will the 'Frame' control help with this?
I cannot believe that this sort of functionality hasn't already been programmed by somebody and I had hoped that such a function was already included in the VB
Maybe there are similar functions in HTML, but I've not used that before either.
Any suggestions anyone?