Hi all
I have an existing excel database which i'd like to 'maintain' with the help of a purpose made Userform. It contains 64 columns of fields (one of which being the record name), with a different row for each record. The database already consists of mainly drop down boxes, with a few free entry (character limited) cells.
So, what i'd like to do is create the Userform. I'm a complete Newb with VBA, but i've done a few tutorials (but all on new databases with new entries each record) and so I understand the basics, but what i'm really looking for is a tutorial that deals with Useforms designed from an existing database where records can be updated as and when required.
Can anybody point me in the right direction please? I'm tempted to purchase a 'VBA for dummies' book but I think something more specific may be useful.
Thanks in advance!
Dave
I have an existing excel database which i'd like to 'maintain' with the help of a purpose made Userform. It contains 64 columns of fields (one of which being the record name), with a different row for each record. The database already consists of mainly drop down boxes, with a few free entry (character limited) cells.
So, what i'd like to do is create the Userform. I'm a complete Newb with VBA, but i've done a few tutorials (but all on new databases with new entries each record) and so I understand the basics, but what i'm really looking for is a tutorial that deals with Useforms designed from an existing database where records can be updated as and when required.
Can anybody point me in the right direction please? I'm tempted to purchase a 'VBA for dummies' book but I think something more specific may be useful.
Thanks in advance!
Dave
