TPFKAS
12-21-2009, 04:10 PM
Hi everybody,
I am looking a way to use Excel as a simple database. Probably it would be easier to do this with access but many people don't have it.
Probably it should be quite simple to do with VB, but I have very little knowledge about this.
Here is what I want to do:
Each row is a record with in the first two columns some names (picked form a list) and the third column a time (hh:mm).
I want the data-input via a form that appears when you press a button like "New Record" or so. When the user opens that form. the user can enter the two names and the time in three fields. The names should be limited to a specified list and should auto-complete when the user types them (rather than picked form a pull-down list). After saving the entry the data should be added in the first empty row below already existing records. Also, very important, the spreadhseet itself should be saved as well after adding the new record.
Can anybody help me how to achieve this?
TIA
I am looking a way to use Excel as a simple database. Probably it would be easier to do this with access but many people don't have it.
Probably it should be quite simple to do with VB, but I have very little knowledge about this.
Here is what I want to do:
Each row is a record with in the first two columns some names (picked form a list) and the third column a time (hh:mm).
I want the data-input via a form that appears when you press a button like "New Record" or so. When the user opens that form. the user can enter the two names and the time in three fields. The names should be limited to a specified list and should auto-complete when the user types them (rather than picked form a pull-down list). After saving the entry the data should be added in the first empty row below already existing records. Also, very important, the spreadhseet itself should be saved as well after adding the new record.
Can anybody help me how to achieve this?
TIA