dagdago
09-05-2007, 03:28 PM
Dear forum users,
I wish to implement database/table that includes 2 columns: serial number and status field.
The serial number should consist of a 9 digits. The status field should contain one of three words (e.g. monkey, donkey and funky :)).
The databse/table should be empty at first and grow as the users insets new rows at will.
* The application should let the user the option either to add or remove new lines at any time.
* It should provide the option of seraching a row by its serial number.
* and should produce cross sections of the databse/table when asked to.
I'm new to VBA/Excel and don't really now its capabilities. Could any one tell me if this is the right tool? In addition a direction to a source code/lead would be welcome.
Thx, dagdago
I wish to implement database/table that includes 2 columns: serial number and status field.
The serial number should consist of a 9 digits. The status field should contain one of three words (e.g. monkey, donkey and funky :)).
The databse/table should be empty at first and grow as the users insets new rows at will.
* The application should let the user the option either to add or remove new lines at any time.
* It should provide the option of seraching a row by its serial number.
* and should produce cross sections of the databse/table when asked to.
I'm new to VBA/Excel and don't really now its capabilities. Could any one tell me if this is the right tool? In addition a direction to a source code/lead would be welcome.
Thx, dagdago